Hyperlink Question

  • Thread starter Thread starter GN
  • Start date Start date
G

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
 
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.
 
Back
Top