Why not just link the the cell you want?

(Add 32 rows to your address when you do the typing???)

nastech wrote:

Hi, almost got to work, have to be close. I have been picking a line in my
document that might be 32 lines past the title line intended. is there a way
to add 32 rows/ lines within the formula? thanks

"Dave Peterson" wrote:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

nastech wrote:

Is there a way to mix use of HYPERLINK, and CELL functions, where reference
to CELL might move with line as document expands / contracts (where line
moves, in line positon). ABSOLUTE cell perhaps.

problem is that "in-document" hyperlink does not maintain integrity for
position.

=HYPERLINK(CELL("row",B469),"x") not working

--

Dave Peterson


--

Dave Peterson