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

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

i believe a free add-in called 'ASAP Utilities' does this (and much more
besides!)


"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

also:
http://www.jkp-ads.com/officemarketplacenm-en.asp

--
Tim Williams
Palo Alto, CA


"Tim Marsh" <tmarsh-trousers-@-take off my trousers to reply-blueyonder.co.uk wrote in message
...
i believe a free add-in called 'ASAP Utilities' does this (and much more
besides!)


"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