hi, dont't know if I can explain.. 2 secs to show but, if you use in document
link to ?? line 900 (have been making link to say line 932), but header line
is at 900, now cut-paste line from line 901, to say line 800.

The header line has now moved to line 901. Next try doing that every couple
minutes, seconds in doing lots of work. move 5-10-50-more lines at once.
Header line is now at position ~ 1000. no longer can find reference to where
trying to do work.............

think answer would be some function, cell line row col offset, to fix header
line as the start position, +32.. feel certain it can be done. thanks



"Dave Peterson" wrote:

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