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

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

That's closer to what I need. I forgot to say I need to imbed the column B
before the ab1623 and ab1624 - kind of a big miss on my part. So the formula
would read
=AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or something
like that?? This of course doesn't work. I can't get the punctuation right.

Text.xls is always pulling from column B in all the tabs in Master.xls
--
Thanks for your help
Lyle


"Biff" wrote:

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

Try this:

=AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624))

Just remember, Master.xls MUST be open for this to work.

Biff

"LyleF" wrote in message
...
That's closer to what I need. I forgot to say I need to imbed the column
B
before the ab1623 and ab1624 - kind of a big miss on my part. So the
formula
would read
=AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or
something
like that?? This of course doesn't work. I can't get the punctuation
right.

Text.xls is always pulling from column B in all the tabs in Master.xls
--
Thanks for your help
Lyle


"Biff" wrote:

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

Biff

Thanks for your time. It works perfectly, as you knew it would.
--
Thanks
Lyle


"Biff" wrote:

Try this:

=AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624))

Just remember, Master.xls MUST be open for this to work.

Biff

"LyleF" wrote in message
...
That's closer to what I need. I forgot to say I need to imbed the column
B
before the ab1623 and ab1624 - kind of a big miss on my part. So the
formula
would read
=AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or
something
like that?? This of course doesn't work. I can't get the punctuation
right.

Text.xls is always pulling from column B in all the tabs in Master.xls
--
Thanks for your help
Lyle


"Biff" wrote:

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