Clarification: using Names on a worksheet gives only the named ranges
specific to that sheet (e.g. Sheet1!TEST1 vs Sheet2!TEST1) - it will not show
unqualified ranges that are defined for the entire workbook, even if they are
on that worksheet.

"Adam" wrote:

Not to waste anyones time with this, but what is the easiest way to get a
collection of ranges that are named in a workbook?

I have tried using Names but it seems to not show all named ranges.

Thanks in advance!

Regards