Confirm Autofilter off

[Chris]

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

 

[Chris Freeman]

Got it: ActiveSheet.AutoFilterMode = False

I wasn't including the mode statement

 

[Tom Ogilvy]

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)