I get an error with ActiveSheet.ShowAllData

G

Guest

I'm trying to write a macro that will reset the worksheet to an unfiltered
list and then filter by a new set of criteria.

In some cases, the macro will be run when there have been no previous
filters. When the macro is run under this scenario, I get an error on the
'ActiveSheet.ShowAllData' command.

I know that I need to somehow tell the macro to ignore the
ActiveSheet.ShowAllData command if there are no existing filteres in place
but I don't know how to do it.

Any help is appreciated!!
 

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

Catch Error on Filter Sub 1
ActiveSheet.ShowAllData 3
Macro / Autofilter / Show All Data 3
Controlling auto-filter with VBA 1
"Run-time error '1004' 5
Bypass a function in a Macro 3
How can I get a macro to know when it false and run a different ma 1
Macro to Un Hide filtered rows 3

Top