If statement with multiple conditions

Hello All,

I have been trying to figure out the best way to use an IF statement requiring multiple conditions. I have the following VBA code below in which I am trying to have Excel find cells in a specific range (UsedRange) which contain a double line at the top of the cell AND are not empty.

Please Login or Register  to view this content.

I have been researching online and do not believe there is an "AND" operator for IF statements in VBA. Any help with finding a work around would be greatly appreciated!

Hello mike703,

For if statements you just kind of stack them so it looks like this:

Please Login or Register  to view this content.

Thanks,

RVASQUEZ

Two excellent ideas, thanks for the fast reply!