| 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 | |||
Linear Mode
