View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default 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