If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

Pat wrote:

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