Maintaining a hyperlink to moved data within the work book

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

If you give A2 a nice name (Insert|Name) and use that name in the hyperlink,
does that help?

Kev Nurse wrote:
>
> 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

--

Dave Peterson