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

--

Use code like the following:

Debug.Print ActiveSheet.AutoFilterMode




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ben" wrote in message
...
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

--

Hi Ben

You can use
ActiveSheet.AutoFilterMode

See Debra's site for more info
http://www.contextures.com/xlautofilter03.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ben" wrote in message ...
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

--

Thanks Chip and Ron.

Ben

--



"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

--

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

--