Listing or Changing all Defined Range Names (using VBA)

[Post Tenebras Lux]

I have a lot of defined range names. I would like to be able to loop through
them and either list them on a worksheet, with their range address in the
adjacent cell; or change the range name to something else based on a specific
criteria.

I can handle all of the above except identifying the "collection" of range
names. Is it like worksheets collection with which I can use a For Each...
loop?

This will help enormously with saving time, and permitting easy documentation.

Thanks in advance

 

[Dave Peterson]

You may want to get 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'll make working with names much, much easier.