Hyperlink Question

[GN]

I hav e a page with sevral hyperlinks inlcuded , the
problem I have is I have a link to say sheet 2 , cell A32

Then insert a row in to (for example) 21 - the hyperlink
remains at A32 when infact i would like it to move to A33.

Thanks in advance

 

[DDM]

GN, select the target cell and define a name for it (Insert > Name > Define)
such as "Target," or whatever. Then hyperlink to that, rather than to the
cell address. Your hyperlink will follow the cell wherever it goes.