Also admit this sheet's private names that designate no region
(TaxRate = 0.21), which have nothing to intersect and belong to the sheet by ownership.
Asked of the sheet's collection by address rather than resolved name by name here: the
collection scope-checks (a name pointing at Sheet2!A1:D4 overlaps this sheet's A1:D4 as
coordinates and is a different region entirely), and it resolves what the names designate as
ONE step. A legacy file carries thousands of names nothing reads; asked one at a time, each
compiled on its own, and a cell report over such a file ran out of memory. Defined names only — a
table's name has its own section.
The defined names whose target region intersects
range, by name.