Excel 2000. Cell A1 has a hyperlink to Cell A2. If I cut and paste A2 to,
say, A3, the hyperlink does not change its destination. A1 is still linked
to A2. How can I get the hyperlink to change its destination to the new
location of the cut and pasted data?

It must be possible, surely.....

Regards
Kev Nurse