Hyperlink Function Problem

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
[email protected]LID

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

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

"Peter Ramm" <[email protected]> wrote in message
news:[email protected]...
>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
> [email protected]LID
>
> Stamp out Spam - See my anti-spam pages:
> http://www.spamfreezone.org

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

Have you tried that.
That is at odds with Help on Hyperlink function - "Link_location can
be a text string enclosed in quotation marks or a cell that contains
the link as a text string." - and it doesn't work for me
--
Pete Ramm
[email protected]LID

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

On Fri, 7 Oct 2005 17:49:41 -0400, "PCLIVE" <[email protected]>
wrote:

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

I can see from Help that that should work - but it doesn't for me - I
get the same error message.

Does that work for you?

I am on Excel 2003 SP2
--
Pete Ramm
[email protected]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
> [email protected]LID
>
> Stamp out Spam - See my anti-spam pages:
> http://www.spamfreezone.org

--

Dave Peterson

On Fri, 07 Oct 2005 18:54:06 -0500, Dave Peterson
<[email protected]> wrote:

>What's the text in A1?
>
>Maybe you need:
>
>=hyperlink("http://" & a1, "test")
>


Doesn't work
--
Pete Ramm
[email protected]LID

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