ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In-Doc Hyperlink ANSWER maintain lines from Cut-Paste (https://www.excelbanter.com/excel-discussion-misc-queries/95881-doc-hyperlink-answer-maintain-lines-cut-paste.html)

nastech

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")



All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com