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