Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to determine if data is filtered
What code could I use to show all rows in the data filtering, IF data
filtering is on. I tried, ActiveSheet.ShowAllData but then it bombs if nothing is already filtered. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to determine if data is filtered
Several ways to check for filter, but to take yours to the next level
On Error Resume Next ActiveSheet.ShowAllData -- -John Please rate when your question is answered to help us and others know what is helpful. " wrote: What code could I use to show all rows in the data filtering, IF data filtering is on. I tried, ActiveSheet.ShowAllData but then it bombs if nothing is already filtered. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to determine if data is filtered
With activesheet
If .FilterMode Then .ShowAllData End If end with or just ignore the error: on error resume next ActiveSheet.ShowAllData on error goto 0 " wrote: What code could I use to show all rows in the data filtering, IF data filtering is on. I tried, ActiveSheet.ShowAllData but then it bombs if nothing is already filtered. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
Code to unfilter if filtered | Excel Programming | |||
Formula to determine row of hi value filtered column | Excel Discussion (Misc queries) | |||
Determine Frequency in Filtered List | Excel Worksheet Functions |