Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to undo autofilters without removing?
Greetings! Would like to undo all autofilter selections (would be
equivalent of selecting All in each one) in the active workbook without removing the autofilters. Is there a VBA function or procedural sequence to accomplish this? Thanks, George |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to undo autofilters without removing?
Hi George,
Try: '============= Public Sub Tester() ActiveSheet.ShowAllData End Sub '<<============= --- Regards, Norman "G Lykos" wrote in message ... Greetings! Would like to undo all autofilter selections (would be equivalent of selecting All in each one) in the active workbook without removing the autofilters. Is there a VBA function or procedural sequence to accomplish this? Thanks, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilters | Excel Worksheet Functions | |||
autofilters | Excel Worksheet Functions | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions | |||
VBA and Autofilters | Excel Programming | |||
Userforms and autofilters - Autofilters don't seen to work with userform | Excel Programming |