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

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


"(E-Mail Removed)" 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
>

On Dec 5, 4:29 pm, excelent <excel...@discussions.microsoft.com>
wrote:
> 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
>
> "pignata...@cox.net" 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- Hide quoted text -
>
> - Show quoted text -

Thank you so much-the outcome is better than what I anticipated!!
Nice to know there are still people out there willig to help one
another.