Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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. -- SuitedAces ------------------------------------------------------------------------ SuitedAces's Profile: http://www.excelforum.com/member.php...o&userid=35840 View this thread: http://www.excelforum.com/showthread...hreadid=556326 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding formula if cel reference is blank | Excel Worksheet Functions | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Cell Reference- Hiding Rows-Urgent | Excel Programming |