In , Dallman Ross <dman@localhost.
spake thusly:

In , Dave Peterson
spake thusly:

Maybe just doing the equivalent of Data|ShowAll would be
sufficient.

Okay, that's promising, but if all is already displayed, I get an
error. So I need an if-statement. Don't know how to formulate
it. Hoping you'll show me.

I found this!

http://www.contextures.com/xlautofilter03.html

If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

I actually had tried something very similar, but it hand't worked.
I had left off "ActiveSheet" and started with the dots.

-dman-