Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?

If you're using the Insert|Hyperlink style of hyperlinks, then give that linked
cell a nice name (insert|Name) and use that in the link.

If you're using the =hyperlink() worksheet function, you could use the same Name
technique or you could modify your formula:

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)

These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the linked sheet.

vanarsdalet wrote:

Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?

--

Dave Peterson

The usual technique is to use Named Ranges:

Insert Name Define

Then when you setup hyperlink "to a place in this document", use the Name as
the reference rather than a specific cell address.
--
Gary''''s Student - gsnu200803


"vanarsdalet" wrote:

Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?

Thanks to both of you !! After about 20 minutes trying to figure out the
naming a cell function, it finally made sense and my day will be much easier
now.

"Gary''''s Student" wrote:

The usual technique is to use Named Ranges:

Insert Name Define

Then when you setup hyperlink "to a place in this document", use the Name as
the reference rather than a specific cell address.
--
Gary''''s Student - gsnu200803


"vanarsdalet" wrote:

Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?