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