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