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
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
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
Bookmarks