Chris, what you're looking for is

Worksheets(1).AutoFilterMode
cheerz!

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Chris Spencer) wrote:

I have a macro in Excel which needs to ensure that autofilters are on
a worksheet certain times and turned off at other times.

At the moment I am just changing the state of the filters with:

Sheets(1).Rows("1:1").AutoFilter

So if filters are on, then this command will turn them off and vice
versa. I need some kind of check to tell whether or not the filters
are on my sheet. Any suggestions.

Thanks in advance.
Chris