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