Maybe you can dump the Insert|Hyperlink and replace them with the =hyperlink()
worksheet function (in an adjacent column).

If you have

in A1

Then you could use:
=hyperlink("mailto:"&a1,"Click me")
or
=hyperlink("mailto:"&a1,a1)
(and hide column A if you want)



Dave S. wrote:

I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

--

Dave Peterson