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