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