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?
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?