INDIRECT function - referencing another workbook

[scubadiver007]

Hello gurus,

I have the following code

Please Login or Register  to view this content.

The figures are returned okay but only if the spreadsheet is open otherwise "#REF!" when it is closed. How do I return the figures if the workbook is closed? I suspect there might be something wrong with the quote marks but not sure what it might be.

Any help appreciated.

[Pete_UK]

INDIRECT does not work with closed workbooks.

Pete

[scubadiver007]

I just discovered that rather bad news!

cheers

[Pete_UK]

All is not lost, however. There is a free Add-in called morefunc which contains the function INDIRECT.EXT, and this will work with closed workbooks. Do a Google search for sites where you can download that from.

Hope this helps.

Pete