Testing for autofilter in macro.

jtush · Apr 9th, 2002, 09:44 AM

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 · Apr 9th, 2002, 11:04 AM

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

Apr 9th, 2002, 11:04 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Why don't you add an errorhandler into your program. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 09:44 AM	#1
jtush New Member Join Date: Apr 2002 Posts: 1	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?