I get an error with ActiveSheet.ShowAllData

  • Thread starter Thread starter Guest
  • Start date Start date
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!!
 
Back
Top