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