mario -

It may be an interesting exercise to "reinvent the wheel" using VBA, but
Excel does already have a menu item for this feature.

In Excel 2003 and earlier versions, choose Insert | Name | Paste | Paste
List.

In Excel 2007, choose Formulas | (Defined Names) Use in Formula | Paste
Names | Paste List.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"mario" wrote in message
...
What will be the vba code to display all the "name" (text) of the named
ranges and its reference range it refers to.

I am trying to create some thing like this

For each rname in Activeworkbook.names.count
msgbox "name is: " & rname.name & "it refers to: " & rname.range
next

Please help.