Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Reference with Hyperlinks
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Reference with Hyperlinks
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Reference with Hyperlinks
On Dec 5, 4:29 pm, excelent
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 " 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative/Current Cell Reference in Hyperlinks | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Reference names and hyperlinks to other files in other directories | Excel Programming |