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=556327 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
How to hide cell reference borders (top/left side) in Excel? | Excel Discussion (Misc queries) | |||
Hide Rows if cell value is | New Users to Excel | |||
hide rows when the cell is #VALUE! | Excel Worksheet Functions | |||
hide rows if cell=0 | Excel Programming |