Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple criteria in autofilter | Excel Worksheet Functions | |||
How do I sum column D and F based on multiple column criteria? | Excel Worksheet Functions | |||
Autofilter Multiple Criteria | Excel Programming | |||
Autofilter Multiple Criteria | Excel Programming | |||
3 Criteria on one column in AutoFilter? | Excel Programming |