Hyperlink Function Problem
 

If you have a link reference in cell A1, then remove the quotes from A1 in
your formula.
=HYPERLINK(A1,"test")

"Peter Ramm" wrote in message
...
I am having a problem with the hyperlink function.

Say b2 contains =HYPERLINK("A1","test")

clicking on b2 produces the error message: "The address of this site
is not valid. Check the address and try again"

--
Pete Ramm
LID

Stamp out Spam - See my anti-spam pages:
http://www.spamfreezone.org

What's the text in A1?

Maybe you need:

=hyperlink("http://" & a1, "test")



Peter Ramm wrote:

I am having a problem with the hyperlink function.

Say b2 contains =HYPERLINK("A1","test")

clicking on b2 produces the error message: "The address of this site
is not valid. Check the address and try again"

--
Pete Ramm
LID

Stamp out Spam - See my anti-spam pages:
http://www.spamfreezone.org

--

Dave Peterson