I get an error with ActiveSheet.ShowAllData

C

csdjj021191

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!!
 
Top