AND condition with multiple OR condtions

[kpasa]

I'm trying to cycle through a table and pull specific rows with certain criteria. So let's say I have a row and I've activated the first cell in the row. In pseudo code here's what I need:

If ActiveCell < Today AND any of these conditions apply
ActiveCell.offset(0,1) is empty
ActiveCell.offset(0,2) is empty
ActiveCell.offset(0,3) is empty

'Then do some code.

How do I pair the AND condition with any one of the OR statements being true?

 

[Eric W]

Try:

    If ActiveCell < Today And (ActiveCell.Offset(0, 1) = "" Or ActiveCell.Offset(0, 2) = "" Or ActiveCell.Offset(0, 3) = "") Then

 

[kpasa]

    If ActiveCell < Today And (ActiveCell.Offset(0, 1) = "" Or ActiveCell.Offset(0, 2) = "" Or ActiveCell.Offset(0, 3) = "") Then

That's exactly what i needed. Thank you!

 

[Eric W]

You're welcome!

 

[Scott Huish]

Unless you are using it as a variable, Today is not a VBA function.

If ActiveCell < Date And (ActiveCell.Offset(, 1) = "" Or activcell.Offset(, 2) = "" Or ActiveCell.Offset(, 3) = "") Then