INDIRECT only works with open spreadsheets. You could try Harlan Grove's
Pull function, which you can get at ftp://members.aol.com/hrlngrv/pull.zip

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Big Al" <Big wrote in message
...
Need to reference values in multiple spreadsheets using function like
INDIRECT, but I can not have all of the spreadsheets open a the same time.