Thank You! Worked like a charm!

Denise

"Tom Ogilvy" wrote:

use the hyperlink worksheet function instead of Insert hyperlinks.

--
Regards,
Tom Ogilvy

"Denise Smiley" <Denise wrote in message
...
I have a spreadsheet with over 5,000 hyperlinks in column D, but I want to
sort on Column A yet I need the hyperlinks to follow in the sort. Right
now
for example the hyperlinks prior to sort in rows 50 to 100 will still be
the
same after the sort. Is there a way that when you sort the hyperlinks
will
follow the data and not stay in the same cell. Denise