Testing for autofilter in macro.

[jtush]

I have some macros that use autofilters.
Sometimes they crash when the autofilter isn't there. Other times I'd like to do a show-all, but if there are no filters active, this crashes. Are there tests for existence of autofilter on a sheet and/or show-all available/not available?

 

[Al Chara]

Why don't you add an errorhandler into your program.