Is there a way in VBA to have criteria not selected instead of criteria selected?
e.g I want to remove XED From field 3 which returns in VBA as :
ActiveSheet.Range("$A$1:$F$1000").AutoFilter Field:=3, Criteria1:=Array( _
"ADL", "AMS", "BJS", "BNE", "FLR", "HHQ", "HNL", "INH", "INV", "IST", "LON", "LVI", "MCY", _
"MEL", "MIL", "MPM", "MQP", "PRG", "RAR", "SFP", "SMY", "SNB", "SYD", "SZG", "VFA", "WSY", _
"ZAG", "ZOL", "ZZZ", "="), Operator:=xlFilterValues
Because that is the criteria it is matching against, however not all codes are on this reportand im only wanting "XED" to be removed from criteria if it is on there... is there a way to do this?
IN Other words - Instead of setting the criteria for the filter, setting the criteria that shouldn't be in the filter.
Bookmarks