Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hondo Chalthoum    on Jan 31 In MS Office Category.

  
Question Answered By: Emily Campbell   on Jan 31

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 ?

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Listing named cells Or get search suggestion and latest updates.


Tagged: