Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Filtering 'Show All' macro
Using Excel 2000, I have created a macro that has the same functionality as
the data toolbar command 'Show All' and assigned it to a command button on the worksheet. How do I modify the macro so that it recognises that the data is unfiltered and prevents a run-time error '1004'message appearing? Regards Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Filtering 'Show All' macro
Sub AA()
If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If End Sub -- Regards, Tom Ogilvy "Andy@d2i" wrote in message ... Using Excel 2000, I have created a macro that has the same functionality as the data toolbar command 'Show All' and assigned it to a command button on the worksheet. How do I modify the macro so that it recognises that the data is unfiltered and prevents a run-time error '1004'message appearing? Regards Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro / Autofilter / Show All Data | Excel Discussion (Misc queries) | |||
Macro - filter - show all data | Excel Worksheet Functions | |||
filtering to show items in a listbox | Excel Discussion (Misc queries) | |||
pivot table duplicates numbers under 'drop down show all'? | Excel Discussion (Misc queries) | |||
Simple macro - show all data | Excel Programming |