View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Multiple column autofilter criteria? Possible?

Is it possible to extend this code to add to an additional custom filter
column to force this condition:

Where (field YachtType=Cat-Sail | Cat-Power) AND (field State=Florida)

At the moment, I have this piece of code operating successfully, but
attempts to introduce a second filter have failed:

Selection.AutoFilter Field:=21, Criteria1:="=Cat-Sail", Operator:=xlOr,
Criteria2:="=*Cat-Tri*"

Thanks for any feedback on this.]

Jason