ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple column autofilter criteria? Possible? (https://www.excelbanter.com/excel-programming/319766-multiple-column-autofilter-criteria-possible.html)

No Name

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





All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com