AutoFilter
 

if Activesheet.AutofilterMode then
Activesheet.AutofilterMode = False
End if

Note that you can not set this property to True to turn on the
Autofilter.

--
Regards,
Tom Ogilvy

"Gareth" wrote in message
...

How, by code, can I check if autofilter is on?

If it is on, switch it off.

Thanks in advance.

Gareth