View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
teepee[_2_] teepee[_2_] is offline
external usenet poster
 
Posts: 10
Default Variables in URL formula help


"Cory" wrote in message
...
Try this:
=HYPERLINK("'http://www.domain.com/" &'[reference.xls]sheet1'!$A$53
&"/[results.xls]results'!$D$2","Link Text")

-Cory

Thanks for trying
Unfortunately that displays a hyperlink rather than the actual value