View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default List all the named ranges & the cells they refer to on a blank she

Sub listdefinednames()
co = 1
For Each n In ActiveWorkbook.Names
'MsgBox n.Name
Cells(co, 1).Value = n.Name
'MsgBox n
Cells(co, 2).Value = n
co = co + 1
Next n
End Sub

--
Don Guillett
SalesAid Software

"Hervinder" wrote in message
...
I have a spreadhseet that has approx 50 named ranged defined.

I would like to list all of the named ranges on a blank sheet and the
cells
they refer to.

is this possible within excel itself or would i have to write a macro to
do
it.

If the macro is the only oprion could some please guide me how to do it.

thank you
Hervinder