![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com