On 22 Feb, 09:26, Dr. Schwartz
wrote:
I would like to turn off the auto filter in sheet3. I can use:

Sheet3.Cells.AutoFilter

to toggle it on and off. I want to make sure that it is off before I run my
code. Can anyone help me determine the autofilter status? And then if it is
on then turn it off.

Thanks
The Doctor

..AutoFilterMode =False