Hi

=Indirect("Tables!$A5:B9")

or

=INDIRECT("Tables!"&SA5:B9)

depending on what you are trying to do.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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