Sort cells and "Place in this document"-hyperlinks

  • Thread starter Thread starter Tom H. Lautenbacher
  • Start date Start date
T

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
 
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
 
Back
Top