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