I tried recording a macro where I went to each worksheet in my workbook and cleared the active filters but when I run the macro later if the page does not have an active filter then I get an error message. Is there a way around this so that the macro will clear all active filters on a page while ignoring the page if it does not have any filters currently applied?
If it's autofilter on regular range. Something like below.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Hi chris,
It seems to me this is a good place to use "On Error Resume Next" in your code.
https://docs.microsoft.com/en-us/dot...rror-statement
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks