Maybe hitting F3 and clicking Paste List would be sufficient.

But I wouldn't use this.

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It makes working with names much, much easier.

Chad wrote:

Is there a way to automate the InsertNamesPasteList function in order to
keep a running tab of the named ranges in a workbook?

Any help would be greatly appreciated,
Chad

--

Dave Peterson