View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default 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