Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range not specific to worksheet
i have a workbook that continually has sheets added to it, often rows are
inserted or removed on the sheet, which shifts the position of the cell i need to address is there a way to create a named range that is not specific to a worksheet i.e.: the name refers to: B36 on whatever the active sheet is.. ....why not just say "B36" ? .... if the user inserts a row at 35:35, the reference would move down 1 row to B37, and i would want the name to refer to that new address... (which would not be correct on a different sheet where the cell to be referenced was at a different position; ....and now i see the implicit problem in the logic... ! ); any direction? thanks in advance... mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range not specific to worksheet
I think the closest thing you can use is the worksheet level names. Then you're
"basename" would be consistent across all the sheets, but the names will follow the cell. Mark Kubicki wrote: i have a workbook that continually has sheets added to it, often rows are inserted or removed on the sheet, which shifts the position of the cell i need to address is there a way to create a named range that is not specific to a worksheet i.e.: the name refers to: B36 on whatever the active sheet is.. ...why not just say "B36" ? ... if the user inserts a row at 35:35, the reference would move down 1 row to B37, and i would want the name to refer to that new address... (which would not be correct on a different sheet where the cell to be referenced was at a different position; ...and now i see the implicit problem in the logic... ! ); any direction? thanks in advance... mark -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to specific cell in named range in Excel formula | Excel Worksheet Functions | |||
Getting a named range to appear in another worksheet | Excel Discussion (Misc queries) | |||
Defining Named Range for Lastrow in a specific column | Excel Discussion (Misc queries) | |||
Selecting specific row/column from a named range | Excel Worksheet Functions | |||
How do I count a named range for a specific word or acronym? | Excel Worksheet Functions |