AutoFilter Property
See AlsoApplies ToExampleSpecificsReturns an AutoFilter object if filtering
is on. Returns Nothing if filtering is off. Read-only.

Remarks
To create an AutoFilter object for a worksheet, you must turn autofiltering
on for a range on the worksheet either manually or using the AutoFilter
method of the Range object.

Example
The following example sets a variable to the value of the Criteria1 property
of the filter for the first column in the filtered range on the Crew
worksheet.

With Worksheets("Crew")
If .AutoFilterMode Then
With .AutoFilter.Filters(1)
If .On Then c1 = .Criteria1
End With
End If
End With



"Ben" wrote:

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

--