Hi, if you are still there, think have found the answer. I combined a couple
of ideas that seem to work:

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



"Jim" wrote:

Hyperlinking to a range name works great until you sort the spreadsheet. Is
there any way to make range names that stay in tact when sorted?
--
Jim in MD


"Dave Peterson" wrote:

You could define a range name, then link to that.

Give Sheet1!C17 a nice range name.

Then you can link to that defined name (insert|hyperlink has an option for Place
in this document).

Or you could use a worksheet formula:
=HYPERLINK("#testname1")



Samad wrote:

When I Hyperlink cells to another sheet's cell and when I move data to other
row/ column or I insert rows/column it does not move hyperlinked address.

Can anyone advice me how to move hyperlink address with insert/move
rows/column/cells.
Thanks

--

Dave Peterson