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