Thread
:
List all the named ranges & the cells they refer to on a blank she
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett