| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
| Problem with hyperlink to .pdf file....please help. | Excel Discussion (Misc queries) | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
Linear Mode
