Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Question
Hyperlinks such as: =HYPERLINK(
=HYPERLINK($A$1&B2,"3") works, but don't know how to fix: =HYPERLINK("webaddress.com="&$A$1,"3") does not. It goes to the web page, but tries to use: $A$1 as final symbol (not what is in cell A1, which is desired) How do I make the 2nd example work? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Question
Hello Nastech, I suspect a typographical error is causing your problem. Recheck the placement of the double quotes. SIncerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=497204 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Question
Thanks, got it. used your idea to check more. Familiar enough to know
should have worked, and had couple problems induced. I should have given a full example. something to laugh at anyways: some =hyperlinks also had a previous link embedded (as in right-click, edit type was present, ha) other: links supplied address for was excluding prefix of "www." ouch couldn't see that till first problem resolved... thanks "Leith Ross" wrote: Hello Nastech, I suspect a typographical error is causing your problem. Recheck the placement of the double quotes. SIncerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=497204 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
excel Hyperlink question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Worksheet Functions | |||
hyperlink question | Excel Worksheet Functions |