hyperlinks DO NOT follow a cel that moved after inserting rows ??????????

[littlepete]

the more i learn in excel, the more (often) i think how stupid this or that effect is ...

i learned to make hyperlinks from a man to his wife's cell...

TODAY i must make the observation that i have to redo all. because the link DOES NOT
follow the cells when they move after inserting new rows ...

please tell me what 'im doing wrong?

pete,
like to learn. hate to be alone ALL the time.

 

[MARK858]

Make the cell a named range then insert hyperlink, click Place in this document and choose the name to associate with the hyperlink, click ok.

Then edit your hyperlink to wherever it is supposed to go to.