Hi all,

I was wondering if there is a way to detect if autofilter is on. I just
want to see if it is select. I don't need to know if it is filtered on a
list.
I trie to looking into the autofilter method/properties, but Id doesn't
appear to true/false state to indicate whether or not it is on.

I just want a way to programmatically check to see if the way I can check it
through the menu: Data-Filter-Autofilter. I just want to check to see if
the check is on, ie, if it is on. Thanks for your help in advance.

Ben

--