| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.ShowAllData
This fails at the last line "ShowAllData method of worksheet class failed" if
there is no filtering active Private Sub CommandButton1_Click() 'Clears all filters Range("A3").Select ActiveSheet.ShowAllData End Sub End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? | Excel Programming | |||
| Troubles with ActiveSheet.ShowAllData | Excel Programming | |||
| ShowAllData | Excel Discussion (Misc queries) | |||
| ActiveSheet.ShowAllData shows everything - way to have hidden _not_ show up? | Excel Programming | |||
| vba-showalldata | Excel Programming | |||
Threaded Mode
