It sounds like you're in business.
Good luck with the tweaks.
Dallman Ross wrote:
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-
--
Dave Peterson