Hello

This is starting to drive me a little bit mad, I hope someone can help!

In a model I'm developing I have a tab that lists all of the named ranges in the workbook, using the
listnames
VBA method. So far so good, works absolutely fine and gives me a list of 158 names.

However, if I count the names in the Immediate window using
ActiveWorkbook.Names.Count
I get 160...

I've even manually counted all of the names in the Name Manager and got 158, so I cannot understand where the extra 2 are coming from!

Has this happened for anyone else? Does anyone know why it's occurring or how to fix it?

Thanks all
Kenny