Create a defined name fx. GoA79

now edit your hyperlink and select defined name

now u can select A79 and pull to another place and hyperlink still find it


" skrev:

Help!
This is probably very easy but I am missing something. Trying to
create a Hyperlink at the top of a worksheet A1 to go to (A79) and I
want to move the cell (A79) in the future but retain the link. I
tried $A$79,A$79 and it will not work. Please advise