Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To find records that have no conditional formatting icon, use an operator of xlFilterNoIcon and do not specify any criteria

Sub FilterByIcon()     Worksheets("SalesReport").Select     Range("A1").AutoFilter     Range("A1").AutoFilter Field:=6,Criteria1:=ActiveWorkbook.IconSets(xl5ArrowsGray).Item(5),Operator:= xlFilterNoIcon End Sub