substitute the filename in a cell reference with a string in anoth
I had not realized that INDIRECT is not needed for the workbook part of
a reference (thanks for the post Naveen). But it certainly is needed
for range specifications in functions
=AVERAGE(INDIRECT("'c:\["&A1&"]sheet1'!X1:X10")
HTH
Kostis Vezerides
|