hyperlink bookmarking?

[Steve Burton]

I am trying to produce a worksheet with hyperlinks in.
The problem is that due to the links being referenced to a
particular cell, when additional information is added the
cell reference changes.
How do I bookmark certain text to reference again for the
links so the when their cell reference changes the link
follows the text?

or is this not a operational function?

 

[Tom Ogilvy]

Give you cell a name (insert=>Name=>Define). Then in the bookmark use the
name as your destination. The name will move.