View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Skinman Skinman is offline
external usenet poster
 
Posts: 54
Default AutoFilter or something like it

Try this without all the = after "

Selection.AutoFilter Field:=2, Criteria1:="GDL", Operator:=xlOr, _
Criteria2:="MTY", Operator:=xlOr, Criteria3:="QRO",
Operator:=xlOr, _
Criteria4:="SLW"



"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"