Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drawn lines paste anywhere not on highlighted cell | Excel Discussion (Misc queries) | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
How do I get a hyperlink to track cut and paste data? | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel |