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