Hiding rows bt reference

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top