How are you using an array with the INDIRECT formula? INDIRECT converts text
string to cell references, but by calling an array, how does XL know which
cell you really want to reference?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Frank" wrote:

I am trying to use Indirect in a defined name. It works fine as long as the
defined name is on that worksheet. But when I try to reference the Defined
Name from another worksheet, the formula appears to resolve to the current
worksheet.

The format I am using is Indirect(Tables!$A5:B9)

If I am on the Tables worksheet not a problem, but when I am on another
worksheet, it resolves to Indirect(A5B9), losing it's reference to the Tables
worksheet.

Got to be a way to get this to work.
Thanks

--
Frank