Dynamic Hyperlink

[Babydum]

Hi

I have a table of contents on a sheet that uses hyperlinks to open other sheets within the same workbook. If i change the sheet names, I have to manually fix the hyperlinks.

Can I get the hyperlink to behave in the same way as a formula in that it adjusts sheet names automatically when they change?

 

[GlennUK]

Use the HYPERLINK function with a call to the CELL function inside, like this:

=HYPERLINK("#"&CELL("address",Contents!C45),"Chapter 13")

 

[Babydum]

Thanks ever so much - works a treat.

 

[GlennUK]

My pleasure