Remove Autofilter

  • Thread starter Thread starter Dr. Schwartz
  • Start date Start date
D

Dr. Schwartz

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
 
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
Click to expand...

..AutoFilterMode =False
 
Hi
As well as .AutoFiltermode = False you might also throw in

On Error Resume Next 'required if Advanced filter used
.ShowAllData
On Error GoTo 0

incase Advanced filter has been applied.

regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba autofilter problem 1
Restore Autofilter After Macro Runs 1
Weird ignoring of one item in a loop 5
Filter and copy data to other sheet 3
array-to-row autofilter issue 3
VBA to set which columns in Autofilter 2
Turn of Autofilter Arrows? 20
AutoFilter Macro Protected Sheet 1

Back
Top