Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My hyperlink address change? | New Users to Excel | |||
Hyperlink: Why am I getting ../../../ in the address bar? | Excel Discussion (Misc queries) | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
How to get 500 hyperlink address efficiently? | Excel Discussion (Misc queries) | |||
hyperlink base address | Excel Discussion (Misc queries) |