I am trying to use the hyperlink function. It wasn't working for me so I
tried in a blank workbook to make a simple hyperlink with the hyperlink
function using the function wizard. I added a value to the cell I linked to
on a different sheet. When I clicked on the hyperlink I received this
message. "The address of this site is not valid. Check the address and try
again". This is the formula I used. =HYPERLINK(Sheet3!C5,"NOW"). Do I
have something set wrong or what am I doing wrong?

Larry: The Hyperlink function is used to open other owrkbooks. Below is the
HJelp on the Hyperlink. If you want to add hyperlinks in the same document
click the right mouse button on the cell you want to add the hyperlink.
Select hyperlink and "select Place in this documnet"

Hyperlink()
Creates a shortcut or jump that opens a document stored on a network server,
an intranet, or the Internet. When you click the cell that contains the
HYPERLINK function, Microsoft Excel opens the file stored at link_location.



"Larry" wrote:

I am trying to use the hyperlink function. It wasn't working for me so I
tried in a blank workbook to make a simple hyperlink with the hyperlink
function using the function wizard. I added a value to the cell I linked to
on a different sheet. When I clicked on the hyperlink I received this
message. "The address of this site is not valid. Check the address and try
again". This is the formula I used. =HYPERLINK(Sheet3!C5,"NOW"). Do I
have something set wrong or what am I doing wrong?

Perhaps you were thinking of something like this ..

Assuming sheetnames listed in A2 down, cell refs in B2 down, Friendly names
(for the links) in C2 down, place in say, D2:
=HYPERLINK("#"&CELL("address",INDIRECT("'"&A2&"'!" &B2)),C2)
Copy D2 down to return the required hyperlinks

Eg if you have in A2: Sheet3, in B2: C5, in C2: NOW
D2 will return a hyperlink named "NOW" which will zip you to Sheet3's C5
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Larry" wrote:
I am trying to use the hyperlink function. It wasn't working for me so I
tried in a blank workbook to make a simple hyperlink with the hyperlink
function using the function wizard. I added a value to the cell I linked to
on a different sheet. When I clicked on the hyperlink I received this
message. "The address of this site is not valid. Check the address and try
again". This is the formula I used. =HYPERLINK(Sheet3!C5,"NOW"). Do I
have something set wrong or what am I doing wrong?

I am trying to use a hyperlink to go to a named range depending upon the
values of two cells concatenated together. Here is what have.
=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!R1:AP 4,2,FALSE))),"PRESS TO
SELECT") The lookup is necessary because of varying values. This returns
the proper named range but when I click on it it says "Cannot open specified
file".

"Max" wrote:

Perhaps you were thinking of something like this ..

Assuming sheetnames listed in A2 down, cell refs in B2 down, Friendly names
(for the links) in C2 down, place in say, D2:
=HYPERLINK("#"&CELL("address",INDIRECT("'"&A2&"'!" &B2)),C2)
Copy D2 down to return the required hyperlinks

Eg if you have in A2: Sheet3, in B2: C5, in C2: NOW
D2 will return a hyperlink named "NOW" which will zip you to Sheet3's C5
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Larry" wrote:
I am trying to use the hyperlink function. It wasn't working for me so I
tried in a blank workbook to make a simple hyperlink with the hyperlink
function using the function wizard. I added a value to the cell I linked to
on a different sheet. When I clicked on the hyperlink I received this
message. "The address of this site is not valid. Check the address and try
again". This is the formula I used. =HYPERLINK(Sheet3!C5,"NOW"). Do I
have something set wrong or what am I doing wrong?

=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!
R1:AP4,2,FALSE))),"PRESS TO SELECT")

This revision of the above worked fine over he
=HYPERLINK("#"&CELL("address",INDIRECT(C5&HLOOKUP( C3,Master!R1:AP4,2,FALSE))),"PRESS TO SELECT")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Larry" wrote:
I am trying to use a hyperlink to go to a named range depending upon the
values of two cells concatenated together. Here is what have.
=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!R1:AP 4,2,FALSE))),"PRESS TO
SELECT") The lookup is necessary because of varying values. This returns
the proper named range but when I click on it it says "Cannot open specified
file".