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.
For Each wCell In ActiveSheet.UsedRange.Cells
If wCell.Borders(xlEdgeTop).LineStyle = xlDouble and _
If IsEmpty(wCell) = False Then
wCell.Interior.ColorIndex = 19
End If
Next wCell
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!
Bookmarks