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
|