hyperlinks & cell reference

[Joerg Cezis]

Hi folks,

Everytime I insert a new column into my Excel table the
hyperlinks which are linked to the cells don't change
automaticlly. Thus I've to change every following
hyperlink per hand.
Is there an option to relate hyperlinks to an other
reference point than the cells?

Thank you for your time in advance

Joerg

 

[Dave Peterson]

If I gave the range a nice name, I could use that in my hyperlink:

Using the =hyperlink() worksheet formula:

=HYPERLINK("#testname","your friendly name here")

TestName referred to c9. Inserting a new column and now it referred to D9.