Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancelling AutoFilter in a macro
Floss,
You can cancel Autofilter with rng.Autofilter Is this what you mean? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Floss" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancelling AutoFilter in a macro
with activesheet
if .filtermode then .showalldata end if end with to show all the data. Or activesheet.autofiltermode = false to remove all the dropdown arrows. Floss wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancelling AutoFilter in a macro
Excellent..
Dave us Gr8..! Thansks! Boss "Dave Peterson" wrote: with activesheet if .filtermode then .showalldata end if end with to show all the data. Or activesheet.autofiltermode = false to remove all the dropdown arrows. Floss wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify the numbers cancelling by amounts | Excel Worksheet Functions | |||
Stop my references cancelling | Excel Discussion (Misc queries) | |||
Cancelling out of an incorrect Replace all | Excel Discussion (Misc queries) | |||
end Macro after cancelling open dialog | Excel Programming | |||
Cancelling the BeforeClose Event | Excel Programming |