Hyperlink - address by formula
 

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

Hyperlink - address by formula
 

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.

--
Regards,
Tom Ogilvy


"Flemming Dahl" wrote in message
...
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

Hyperlink - address by formula
 

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),sheeton e!A9)
=HYPERLINK("#"&CELL("address",'sheet two'!A9),'sheet two'!A9)

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Flemming Dahl" wrote in message ...
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