=indirect() won't work with closed workbooks.
Harlan Grove wrote a User Defined Function that can pull from a closed
workbook:
http://groups.google.co.uk/groups?se...wsranger.co m
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Antonio Duarte wrote:
Does someone has an answer for the question below?
I have a cell (say A1) with the formula:
=HYPERLINK(€œ[d:\tmp\file.xls]sheet!B11")
In the next cell, I would like to see the value that the cell pointed by the
hyperlink has. I tried:
=INDIRECT(A1)
But Excel gives a #REF error in the INDIRECT function.
Does someone have any idea on how can I solve this?
Thanks a lot
Antonio Duarte.
--
Dave Peterson