Better to see so send to me if you like at dguillett1 @gmail.com or
a double click event macro to select the column. I use this often for
Key1:=3DCells(mr + 1, ActiveCell.Column), Order1:=3Dxlascending, _
Header:=3DxlGuess, OrderCustom:=3D1, Orientation:=3DxlTopToBottom
On Feb 7, 4:50=A0am, "Tom H. Lautenbacher" <use...@tom.lautenbacher.biz>
> 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