Hi!

Try this:

:=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))

Note - if this is being used in TEST.XLS then MASTER.XLS must be open for it
to work.

Biff

"LyleF" wrote in message
...
I am using Indirect fine within the WS 'Test' but cannot get it to grab
info
from another WS within a nested function. Ex:
=AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
b1330:b1617 to be an indirect call from the original worksheet 'Test'.
ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This
gives me a highlight error at "AB".
Thanks
Lyle