ExcelBanter - How can I sort hyperlinked cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I sort hyperlinked cells? (https://www.excelbanter.com/excel-discussion-misc-queries/197942-how-can-i-sort-hyperlinked-cells.html)

Midjack

How can I sort hyperlinked cells?

Trying to sort cells that have been hyperlinked. The sorted text sorts as
expected, but the hyperlink stays in it's original location. Is there a way
to overcome this? I'm using Excel 2007.

All times are GMT +1. The time now is 11:24 PM.