Posted to microsoft.public.excel.programming

Dr. Schwartz[_2_] Dr. Schwartz[_2_] is offline

external usenet poster

Posts: 30

Remove Autofilter

I would like to turn off the auto filter in sheet3. I can use:

Sheet3.Cells.AutoFilter

to toggle it on and off. I want to make sure that it is off before I run my
code. Can anyone help me determine the autofilter status? And then if it is
on then turn it off.

Thanks
The Doctor

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 autofilter change to 2003 autofilter functionality?	jonnybrovo815	Excel Discussion (Misc queries)	1	April 19th 10 10:05 PM
2007 excel autofilter back to 2003 autofilter?	jonnybrovo815	Excel Discussion (Misc queries)	3	April 19th 10 08:11 PM
2007 excel autofilter change back to 2003 autofilter?	jonnybrovo815	Excel Discussion (Misc queries)	1	April 19th 10 05:53 PM
remove autofilter from some columns	Capp	Excel Programming	3	June 8th 06 10:44 PM
Remove Autofilter	ilyaskazi[_68_]	Excel Programming	4	September 8th 05 02:15 PM

All times are GMT +1. The time now is 10:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us