ShowAllData

P

Pat

When a macro runs and it performs a filter/showall request the code stops on
the line:

ActiveSheet.ShowAllData

What needs to be changed so that this request is always performed regardless
if the sheet is not currently filtered.

Thanks if you can help.
Pat
 
P

Pat

Thank you gentlemen for your help. I found Dave's solution best suited for
this task.

Cheers
Pat
 
Top