Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula: Add rows/lines to destination in Hyperlink
trying to have an in-document hyperlink, that has a way of fixing a position,
so as lines are entered/removed around, then link stays in same spot. I spend half my time resetting cell references in large document, to navigate. Example have is: =HYPERLINK("#"&CELL("address",A82),"top") need help to include: add 32 lines past A82 example, thanks Istead of picking ~32 lines after my real destination (where cut-pastes above my "title-line", would cause every thing to shift & hyper-link to be off, way too often),,, maybe I need to use the exact title line as the reference & add 32 lines past it, within the formula. possibly need to use an Absolute Cell Reference? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula: Add rows/lines to destination in Hyperlink
This'll point at A114 no matter what you delete/insert.
=HYPERLINK("#"&CELL("address",INDIRECT("A114")),"t op") nastech wrote: trying to have an in-document hyperlink, that has a way of fixing a position, so as lines are entered/removed around, then link stays in same spot. I spend half my time resetting cell references in large document, to navigate. Example have is: =HYPERLINK("#"&CELL("address",A82),"top") need help to include: add 32 lines past A82 example, thanks Istead of picking ~32 lines after my real destination (where cut-pastes above my "title-line", would cause every thing to shift & hyper-link to be off, way too often),,, maybe I need to use the exact title line as the reference & add 32 lines past it, within the formula. possibly need to use an Absolute Cell Reference? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Hyperlink Formula to call up browser | Excel Worksheet Functions | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
hyperlink formula | Excel Discussion (Misc queries) |