Hi
Just suppress the error

On Error Resume Next 'required if Advanced filter used
.ShowAllData
On Error GoTo 0
.AutoFilterMode = False 'Removes drop down arrows

regards
Paul

On May 11, 3:55*pm, Ted M H wrote:
I need a way to clear any and all AdvancedFilter on a worksheet so that all
rows are displayed. *I've tried the ShowAllData method and it works fine as
long as there are filtered rows on the sheet. *But the method fails if there
are no filtered rows.

Is there a way ShowAllData regardless of whether rows are filtered? *If not,
is there a way to check for AdvancedFilter--a sort of AdvancedFilter property?

Many thanks.