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

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...

--
Thanks,

Scott

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

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

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"SQLScott" wrote:

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...

--
Thanks,

Scott

Programatically get to Named Ranges in Name Manager (Office 20
 

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

--
Thanks,

Scott


"John Bundy" wrote:

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

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"SQLScott" wrote:

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...

--
Thanks,

Scott