How do I create a hyperlink to a cell with the hyperlink function
 

I am trying to link from one cell to another in Excel 2003 with the hyperlink
function. When I use the following format shown in the hyperlink function
help, it does not work.

=HYPERLINK("[Budget]June!E56", E56)

I have also tried removing the file name ([Budget]) and the double quotes. I
have tried using the single quotes around the sheet name ('June') as in a
cell reference, but the link still does not work.

How do I create a hyperlink to a cell with the hyperlink function
 

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

S. Bevins wrote:

I am trying to link from one cell to another in Excel 2003 with the hyperlink
function. When I use the following format shown in the hyperlink function
help, it does not work.

=HYPERLINK("[Budget]June!E56", E56)

I have also tried removing the file name ([Budget]) and the double quotes. I
have tried using the single quotes around the sheet name ('June') as in a
cell reference, but the link still does not work.

--

Dave Peterson

How do I create a hyperlink to a cell with the hyperlink function
 

i've never used that function before but this worked for me

=HYPERLINK([Book2]Sheet1!$E$56,"E56")

*edit* beaten to the punch


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563434