S
SuitedAces
Please offer me some help and education with this;
I have a named cell on a sheet.
There are a large number of buttons that will each toggle a row
hidden/unhidden.
The 1st button will hide/unhide a row 3 rows below the named cell.
The 2nd button will hide/unhide a row 6 rows below the named cell.
and so on..... the 3rd button 9 rows below.
I would like to call one sub and use a variable.
And I would like to have the code determine the row in reference to
the
named cell.
So that if rows are ever inserted above the range the rows that are
toggled hidden/unhidden will maintain that distance from the named
cell.
Thank you for your help.
I have a named cell on a sheet.
There are a large number of buttons that will each toggle a row
hidden/unhidden.
The 1st button will hide/unhide a row 3 rows below the named cell.
The 2nd button will hide/unhide a row 6 rows below the named cell.
and so on..... the 3rd button 9 rows below.
I would like to call one sub and use a variable.
And I would like to have the code determine the row in reference to
the
named cell.
So that if rows are ever inserted above the range the rows that are
toggled hidden/unhidden will maintain that distance from the named
cell.
Thank you for your help.