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

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