how to get the names that defined in excel?

[Guest]

can i get the names defined in excel?

 

[Dave Peterson]

Maybe...
Insert|Name|Paste

Or...

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

 

[Guest]

using c#code to accomplish
--
marxi

Maybe...
Insert|Name|Paste

Or...

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

 

[Dave Peterson]

Good luck.

using c#code to accomplish

 

[Debra Dalgleish]

In Excel, you could turn on the macro recorder, and manually create the
list of names, as Dave described.

Then, you may be able to incorporate that code in your other project.

 

[Michael Bednarek]

can i get the names defined in excel?

Sub ListAllNames()

Dim namName As Name

For Each namName In Application.Names
Debug.Print "Name: " & namName.Name & ", RefersTo: " & namName.RefersTo
Next namName

End Sub