How did you create the hyperlink?
The only way it would adjust would be if you used the HYPERLINK
worksheet function, e.g.
=HYPERLINK(Sheet2!A1, "Go to " & Range("A1").Address)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup