paquirl
Board Regular
- Joined
- Oct 12, 2010
- Messages
- 226
- Office Version
- 2016
- Platform
- Windows
After filtering a column for a fill color yellow:
I want to then do an IF THEN logic command as follows: IF no yellow filled cells exist in Field:=11, THEN skip to another step (4 steps down). Can anyone help me figure out how to do this IF THEN command?
Code:
ActiveSheet.Range("$A$1:$AB$1217").AutoFilter Field:=11, Criteria1:=RGB(255 _
, 255, 0), Operator:=xlFilterCellColor
I want to then do an IF THEN logic command as follows: IF no yellow filled cells exist in Field:=11, THEN skip to another step (4 steps down). Can anyone help me figure out how to do this IF THEN command?