Cell names do not move when you sort, so it is not surprising that the
hyperlinks to those named ranges remain the same.

The only way I can think of to do it would involve a number of
worksheet functions: HYPERLINK, MATCH and OFFSET

Supposing that the place you wanted to link to was in column 4 of a
table named MyTable, on the row in which the first cell contained the
value which is in cell A2 on the sheet containing the hyperlink.

=HYPERLINK(OFFSET(MyTable,MATCH(A2,OFFSET(MyTable, 0,0,,1),0)-1,3,1,1),
"Text you want to show")

Then, when you sort MyTable, the link will still go to cell in column 4
on the row beginning with the item you require

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