Hyperlink - address by formula

  • Thread starter Thread starter Flemming Dahl
  • Start date Start date
F

Flemming Dahl

Hi

I'd like to create af Hyperlink that jumps to a specific cell - there can be
inserted rows above this cell and columns left of this cell

I have with no luck tryed to determin this cell by inserting af formula for
the hyperlink reference like this.
Cell("Address",Offset(A1;8,0,1,1)) (might be english errors there - using a
danish version) but the hyperlink function will not allow this.

Can it be done and how ?

Thanks
Flemming
 
I created a defined name
insert =>Name =>Define

Name: Dog1
Refersto: =OFFSET(Sheet3!$A$1,COUNTA(Sheet3!$A:$A),3,1,1)

then went to another sheet and inserted a hyperlink.

I chose bookmark (xl2000) and it offered the sheetnames and one defined
name that was a hardcoded range, but not Dog1. I selected the hardcoded
name, then before clicking OK, I typed over it and put Dog1

It worked fine. I added some numbers in column A of the target sheet, then
went back to the sheet with the hyperlink and the hyperlink took me to the
newly calculated location.
 
Hi Flemming,
See my page http://www.mvps.org/dmcritchie/excel/sheets.htm
particularly new notes in blue near the rest of the HYPERLINK
worksheet formulas. Works in Excel 97 and up.

=HYPERLINK("#A9",a9)
=HYPERLINK("#"&CELL("address",A9),A9)
=HYPERLINK("#"&CELL("address",sheetone!A9),sheetone!A9)
=HYPERLINK("#"&CELL("address",'sheet two'!A9),'sheet two'!A9)
 
Back
Top