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