What is the best way to link to another place in an XL97 workbook?
I could not find any bookmark or goto function. I could do it with VBA and a button, but I prefered a simple hyperlink equation.
My solution was:
S4: =CELL("filename",References!$C$1)
N1: =HYPERLINK(MID($S$4,SEARCH("[",$S$4),LEN($S$4)-SEARCH("[",$S$4)+1)&"!$A$1","REFERENCE")
This works and will accomodate both workbook name and sheet name changes but will fail if the target cell $C$1 is deleted.
I tried Insert > hyperlink, but that failed as soon as I saved the workbook with a new name.
Thanks in advance
Brian
I could not find any bookmark or goto function. I could do it with VBA and a button, but I prefered a simple hyperlink equation.
My solution was:
S4: =CELL("filename",References!$C$1)
N1: =HYPERLINK(MID($S$4,SEARCH("[",$S$4),LEN($S$4)-SEARCH("[",$S$4)+1)&"!$A$1","REFERENCE")
This works and will accomodate both workbook name and sheet name changes but will fail if the target cell $C$1 is deleted.
I tried Insert > hyperlink, but that failed as soon as I saved the workbook with a new name.
Thanks in advance
Brian