View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr. Schwartz[_2_] Dr. Schwartz[_2_] is offline
external usenet poster
 
Posts: 30
Default Remove Autofilter

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