Confirm Autofilter off

Can someone help with code turn simply state that the autofilter is turned
off. Or to confirm the status of autofilter: ie. Application.autofilter=false

Thanks

Got it: ActiveSheet.AutoFilterMode = False

I wasn't including the mode statement

"Chris" wrote:

> Can someone help with code turn simply state that the autofilter is turned
> off. Or to confirm the status of autofilter: ie. Application.autofilter=false
>
> Thanks

ActiveSheet.AutoFilterMode
if true then the arrows of the autofilter are visible.

ActiveSheet.FilterMode
if true then there is a filter criteria applied. (beside all)

--
Regards,
Tom Ogilvy


"Chris" <[email protected]> wrote in message
news:[email protected]...
> Can someone help with code turn simply state that the autofilter is turned
> off. Or to confirm the status of autofilter: ie.
Application.autofilter=false
>
> Thanks