Hi Gord,

InsertNamesPastePaste List.

A good suggestion but subject, I think, to the possible drawback that it
will not list sheet level (local) names relating to the non-active sheet.


---
Regards,
Norman



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
John

InsertNamesPastePaste List.


Gord Dibben MS Excel MVP

On Sun, 15 Jan 2006 17:51:02 -0800, "John"

wrote:

Is there any way to print our or export the names of all the named ranges
I
have?

Is there any way to tell if I'm getting close to running out of room for
more named range definitions?