Jump to cell

[ickleyates]

Hi,

I have set up a link to a cell in a worksheet, but when I make alterations
to the worksheet e.g. delete a column the hyperlink remains with the cell not
the contents, as if e.g. $A$1. Is there a way to avoid this?

Many Thanks,

J.

 

[Tom Hutchins]

You must mean a link to a sheet in another workbook. If both cells are within
the same workbook you shouldn't have this problem.

Assign a range name to the cell in the source workbook, then recreate the
link from the other workbook. Excel will find the named cell in the source
workbook even if its row and/or column has changed.

Hope this helps,

Hutch

 

[Nastech]

hi, am curious how to "assign a range name". I had wrestled with this
question before, was able to devise: paste the following inside a cell,
then click on destination, then type: ),"x")
(use $ signs in cell destination to make fixed / absolute, e.g.: $A$1)

=HYPERLINK("#"&CELL("address",

should take you to other locations, to be:
=HYPERLINK("#"&CELL("address",$A$1),"x")

i use the following to move around a document
=HYPERLINK("#"&CELL("address",OFFSET($A$981,IF(ROW($A$981)>ROW($A458)-$AA$3/4,$AA$3,-1),0)),"X")

$AA$3 is the size of your sheet showing, in rows; $A458 is the row you are
in.
thanks.