clearing an advanced filter

  • Thread starter Thread starter dcorey
  • Start date Start date
D

dcorey

I'm new to xl programming and need to know how to clear an advanced
filter programatically.


I'm applying a filter within the program to a named range, but I can't
clear the filter and redisplay all the data. If I use
activesheet.showalldata, it works if the range is filtered, but
generates an error if the range is already completely displayed.

Thanks
 
If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData

--
Jim
| I'm new to xl programming and need to know how to clear an advanced
| filter programatically.
|
|
| I'm applying a filter within the program to a named range, but I can't
| clear the filter and redisplay all the data. If I use
| activesheet.showalldata, it works if the range is filtered, but
| generates an error if the range is already completely displayed.
|
| Thanks
|
 

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

Code to unfilter if filtered 1
Advanced Filter Error - I cannot spot my Error 3
Problems copy data when using filter in place 3
How do I identify range of filtered sheet? 5
Controlling auto-filter with VBA 1
Macro Breaks When criteria is deleted 3
Advanced Filter... 2
advanced filter office 2007 1

Back
Top