I misinterpreted your answer. AND understand adding
makes it active.
BUT, then *after* Adding, we get the active workbook name (for
getting the range names). (I was assuming this was the original
workbook Name, not the Added one)
I think this tells me that Range names are actually in the
Application Object (not the Workbook) - along with the fact that my
other way of getting the Range Names uses the Application Object.
[Application.Names.Item(x)]
[Application.Names.Item(x).Name]
The fact that these are valid:
[ThisWorkbook.Names.Item(x)]
[ThisWorkbook.Names.Item(x).Name]
is because Excel allows referencing a lower object in the accession,
right?
The full accession must be (and these are valid):
[Application.ThisWorkbook.Names.Item(x)]
[Application.ThisWorkbook.Names.Item(x).Name]
Have I got it now ?