ShowAllData

[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

 

[Dave Peterson]

If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

 

[Trevor Shuttleworth]

Pat

maybe just use:

Selection.AutoFilter

as a toggle

Regards

Trevor

 

[Pat]

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

Cheers
Pat