Hyperlink to cell that contains certain text

[ExcelFailure]

Hello and thanks..

I have a spreadsheet that has a contents page on, with a list of words as hyperlinks, that link to that same word on another sheet. However when I insert rows, the hyperlinks to the words below where I have added a row go out of sync

Is there anyway that I can link the hyperlink to a cell that contains certain text, so that it will follow it around?

Many thanks

 

[craig.penny]

Try making your target cell a named range. Then edit your Hyperlinks to link to the Defined Name instead of the Cell Reference. I did this and tested it out in Excel 2007 and it was pretty easy.