View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sameer.phadke@gmail.com is offline
external usenet poster
 
Posts: 1
Default Dynamic Hyperlink

Hi:

I have a cell reference being calculated as a formula. (for example:
formula in cell C2 results in the string Names!$F$5).

I need a hyperlink in a cell to link to the address being computed. I
tried =HYPERLINK(C2,"testlink")

When I click on the hyperlink 'testlink', I get an error saying "Cannot
open specified file".

What am I doing wrong?

Sameer