G
Guest
Guest
The INDIRECT function brings up a #REF! error if you try and reference a workbook that is closed, however it works fine if the workbook is open. Is there anyway around this problem?
On 2002-02-25 07:05, Andrew XJ wrote:
You can find from the Excel 97 help that the workbook referenced by INDIRECT muse be open. I don't know whether Excel 2000 has any improvement on this.