Posted to microsoft.public.excel.programming

Brian Bermingham[_2_] Brian Bermingham[_2_] is offline

external usenet poster

Posts: 11

Reset AutoFilter in code

Hi

I know how to remove AutoFilter.
Worksheets("Absence").AutoFilterMode = False

But how can I leave the autofilter in place just removing any applied filter?
Some thing like AutoFilter.reset !

Thanks

Brian

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
Workbook Reset AutoFilter to ShowAll	David J[_3_]	Excel Programming	1	November 29th 07 02:31 AM
Reset VB Code Not Working on Close	Jane	Excel Programming	6	April 10th 06 05:29 PM
Master reset code bug - stumped again	peter.thompson[_28_]	Excel Programming	1	January 7th 06 07:38 AM
Master reset code -stumped	peter.thompson[_24_]	Excel Programming	6	January 7th 06 01:35 AM
Autofilter reset button	Cheese	Excel Discussion (Misc queries)	6	July 9th 05 06:39 PM

All times are GMT +1. The time now is 07:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us