Thanks, I used the Advanced Filter and that did the trick.
"Ron de Bruin" wrote:
Hi pgarcia
The max = 2 criteria with AutoFilter
You can use advancedfilter with your criteria in a range
What do you want to do with the filter result
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"pgarcia" wrote in message ...
Shouldn't this work? This is part of a greater VB code. I will post it after
this one.
Selection.AutoFilter Field:=2, Criteria1:="=GDL", Operator:=xlOr, _
Criteria2:="=MTY", Operator:=xlOr, Criteria3:="=QRO",
Operator:=xlOr, _
Criteria4:="=SLW"