View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default 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