Criteria and Autofilter

[Bill]

Hello,
Using VBA, is there a way to determine the number of criteria listed in a
filter for a column and what the individual criteria are?

Thanks.

Bill

 

[Frank Kabel]

Hi
in the Excel VBA help (looking for the Autofilter Object) is a quite
extensive example for querrying the Autofilter status

 

[Dave Peterson]

One way is to use the code that John Walkenbach has on his site (from Stephen
Bullen):

http://j-walk.com/ss/excel/usertips/tip044.htm