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