View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default In-Doc Hyperlink ANSWER maintain lines from Cut-Paste


After much search / told can't do it.. :)
Found what may be the answer. Not sure if all items are necessary, maybe
someone can comment on if anything incorrect / not needed in this formula.
(this works anyways)

Have found what believe to be answer for keeping Hyperlink "Line-Locations"
intact from Cut-Paste of lines.
- z1 is for absolute cell reference to adjust # rows down (size of your
screen, e.g.: 32)
- 1st examples for top of document, last example for "in-document", ROW()
for line you place link in.

=HYPERLINK("#"&CELL("address",OFFSET(A505,$Z$1,1)) ,"x") for downward link
in document
=HYPERLINK("#"&CELL("address",OFFSET(A505,-1,1)),"x") for up

=HYPERLINK(IF(ROW($A$253)=ROW($A764),"#"&CELL("ad dress",OFFSET($A$253,$Z$1,1)),"#"&CELL("address",O FFSET($A$253,-1,1))),"x")