hyperlink bookmarking

  • Thread starter Thread starter steve Burton
  • Start date Start date
S

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?
 
Hi Steve,
With RightClick on cell and enter hyperlink, you do not have that
problem, so expect you are using HYPERLINK Worksheet Function
[Being more explicit when asking questions generally gets the best
replies -- unless it is too much information].

When you enclose the address in double quotes it will not change.
You can code so that the address will change but using the following
=HYPERLINK("#" & cell("address", sheet4!F5), sheet4!F5)
you will find this on my
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink (see blue text)

I also have a page oriented to working with bookmarks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
 
Back
Top