Formula: Add rows/lines to destination in Hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This'll point at A114 no matter what you delete/insert.

=HYPERLINK("#"&CELL("address",INDIRECT("A114")),"top")
 
Back
Top