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"?