Sort cells and "Place in this document"-hyperlinks

[Tom H. Lautenbacher]

Dear group,

I am using a table with multiple columns that are used as a database.
Each column is one data entry. I am having some hyperlinks that point
from one data entry (i.e. column) to another inside the spreadsheet.

Unfortunately, when I perform a sort of the columns, these hyperlinks
remain pointing to the previous location inside the sheet, i.e. to the
wrong column after the sort.

How do I solve this, i.e. how I make Excel understand that these
hyperlinks need to be updated while sorting the table?

Thank you for any advice
Tom

 

[Don Guillett]

Better to see so send to me if you like at dguillett1 @gmail.com or
try
a double click event macro to select the column. I use this often for
sorting columns

Range("sortarea").Sort _
Key1:=Cells(mr + 1, ActiveCell.Column), Order1:=xlascending, _
Header:=xlGuess, OrderCustom:=1, Orientation:=xlTopToBottom