LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Cancelling AutoFilter in a macro

Hi,

Need help with macro code that will clear all of the active filter opions on the auto filter.
I tryied taking out the filter and putting back with instructions hoping that after taking it out, all prior filter choices would be wiped clean. But that doesnot seem to always work, as when the filter is reactivated (Application.AutoFilter) prior filters are still active.

Thank you in advance.
Floss
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
identify the numbers cancelling by amounts Radhakant Panigrahi Excel Worksheet Functions 0 April 22nd 10 03:44 PM
Stop my references cancelling Mahhrat Excel Discussion (Misc queries) 1 July 24th 08 07:46 AM
Cancelling out of an incorrect Replace all [email protected] Excel Discussion (Misc queries) 2 July 11th 06 12:13 PM
end Macro after cancelling open dialog No Name Excel Programming 1 June 29th 04 08:58 AM
Cancelling the BeforeClose Event Troy[_5_] Excel Programming 6 December 2nd 03 06:40 AM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"