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" <[email protected]> wrote in message
news:[email protected]...
>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
Bookmarks