![]() |
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