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
|