Programatically get to Named Ranges in Name Manager (Office 2007)

S

SQLScott

Hello everone,

I have been trying all day to figure out how to programatially access the
Named Ranges in Name Manager.

An an FYI, manually they are seend by selecting the Formulas tab and then
selecting Name Manager.

I need to figure out how to get to these programatically.

Any insight is greatly appreciate...
 
J

John Bundy

Try this
Dim myName As Name
For Each myName In ThisWorkbook.Names
MsgBox myName.Name
Next
 
S

SQLScott

YOU, my friend, are a genius. So, what I need to do now is grab the
associated RefersTo value for that. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Multiple Named Ranges 5
Selecting multiple named ranges 1
How to get named range value? 5
Named Ranges in various sheets 1
select multiple named ranges with macro 4
Maximum Named Ranges in Excel? 0
Copy worksheet with named ranges to new workbook and keep names in 1
Problem with progamatically defined named ranges 3

Top