Sort cells and "Place in this document"-hyperlinks

  • Thread starter Tom H. Lautenbacher
  • 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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top