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