Alternative way to refer to a row to hide or unhide...
Hi There, I currently have a simple VB that selects data in row 60 and 61 (see below). Problem is that if a user adds lines (and its quite possible that he may) the macro will not hide the correct row. Is there VB to hide a named range...? Kind regards Darin Rows("60:61").Select Selection.EntireRow.Hidden = True *** Sent via Developersdex http://www.developersdex.com *** |
Alternative way to refer to a row to hide or unhide...
Select the rows you want hidden, click in the address window (upper left of
sheet where you see the cell reference). Type a name in that window to give the selected rows a "Named Range". Then put that name in your code in place of the rows reference. This way, when rows are added above, the named range will remain constant. -- Best wishes, Jim "Darin Kramer" wrote: Hi There, I currently have a simple VB that selects data in row 60 and 61 (see below). Problem is that if a user adds lines (and its quite possible that he may) the macro will not hide the correct row. Is there VB to hide a named range...? Kind regards Darin Rows("60:61").Select Selection.EntireRow.Hidden = True *** Sent via Developersdex http://www.developersdex.com *** |
Alternative way to refer to a row to hide or unhide...
Assign a Named Range to the rows and use the name:
Sub demo() Range("ready_for_hide").EntireRow.Hidden = True End Sub The named cells will adjust as rows are added or deleted. -- Gary''s Student gsnu200706 "Darin Kramer" wrote: Hi There, I currently have a simple VB that selects data in row 60 and 61 (see below). Problem is that if a user adds lines (and its quite possible that he may) the macro will not hide the correct row. Is there VB to hide a named range...? Kind regards Darin Rows("60:61").Select Selection.EntireRow.Hidden = True *** Sent via Developersdex http://www.developersdex.com *** |
Alternative way to refer to a row to hide or unhide...
|
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com