| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Macro after it has run
I have successfullu run a Macro to hide certain rows that have zero sum
value, however I need guidance in being able to refresh my page once this has been down. In order words, beside unhiding the rows that have been hidden to start over, how can I reverse my Macro? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverse Macro after it has run
Unhide them:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 5/20/2008 by James Ravenswood ' ' Cells.Select Selection.EntireRow.Hidden = False End Sub -- Gary''s Student - gsnu200787 "Mike" wrote: I have successfullu run a Macro to hide certain rows that have zero sum value, however I need guidance in being able to refresh my page once this has been down. In order words, beside unhiding the rows that have been hidden to start over, how can I reverse my Macro? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverse Macro after it has run
Worked! Thanks
"Gary''s Student" wrote: Unhide them: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 5/20/2008 by James Ravenswood ' ' Cells.Select Selection.EntireRow.Hidden = False End Sub -- Gary''s Student - gsnu200787 "Mike" wrote: I have successfullu run a Macro to hide certain rows that have zero sum value, however I need guidance in being able to refresh my page once this has been down. In order words, beside unhiding the rows that have been hidden to start over, how can I reverse my Macro? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reverse value | Excel Worksheet Functions | |||
| reverse value | Excel Worksheet Functions | |||
| Reverse column order with a macro | Excel Discussion (Misc queries) | |||
| Reverse Sum | Excel Discussion (Misc queries) | |||
| Reverse a Macro - works like back button | Excel Discussion (Misc queries) | |||
Hybrid Mode
