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

Confirm Autofilter off
 

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

Confirm Autofilter off
 

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" wrote in message
...
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