Retrieving the Collection of Ranges in a Workbook
 

Names is the property that is designed to give you all the named ranges. Can
you give some examples of where/how it is failing? The only thing I can
think that might give a wrong result is if you are using Names on a worksheet
object qualifier instead of the Workbook (if you did ActiveSheet.Names it
would only give the names on the active worksheet, but ThisWorkbook.Names
should give them all).

"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