Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove autofilter results with a macro
I can't seem to find anything similar to this. I'm trying to setup a macro
that will unfilter the sheet if the autofilter has been engaged. I can get it to work as long as at least 1 column has been autofiltered, but if none has been I get a run time error 1004. So then I tired a If then, but it keeps hanging on part of the field. Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove autofilter results with a macro
As ALWAYS, post your code for comments
-- Don Guillett Microsoft MVP Excel SalesAid Software "Muth69" wrote in message ... I can't seem to find anything similar to this. I'm trying to setup a macro that will unfilter the sheet if the autofilter has been engaged. I can get it to work as long as at least 1 column has been autofiltered, but if none has been I get a run time error 1004. So then I tired a If then, but it keeps hanging on part of the field. Thanks for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove autofilter results with a macro
With worksheets("Input")
'to remove the filter and the arrows .AutoFilterMode = False 'or to just show all the data and keep the arrows If .FilterMode Then .ShowAllData End If End With You could have ignored the error, too: on error resume next ActiveSheet.ShowAllData 'keeps the arrows, shows all the data. on error goto 0 Muth69 wrote: I can't seem to find anything similar to this. I'm trying to setup a macro that will unfilter the sheet if the autofilter has been engaged. I can get it to work as long as at least 1 column has been autofiltered, but if none has been I get a run time error 1004. So then I tired a If then, but it keeps hanging on part of the field. Thanks for your help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter results | Excel Discussion (Misc queries) | |||
at excel start need macro to remove autofilter & apply sort mult t | Excel Programming | |||
Using autofilter results | Excel Programming | |||
Copy Autofilter results macro | Excel Programming | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |