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
 

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

Back
Top