View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trimm54
 
Posts: n/a
Default Hyperlink using filename

I am trying to hyperlink to a different worksheet in the same workbook using
the hyperlink and cell functions. Here is the formula:

=HYPERLINK(CELL("filename",GMT96X_PMC_PDU_ReWork!A 10 ),"RW")

When clicking on the hyperlink a window pops up "Cannot open the specified
file." I believe the issue is with the path that is created with filename
and the other worksheet / cell reference, but I do not see it.

All help is appreceiated.
--
rst