ActiveWorkbook.Names rogue entries

[Gates Is Antichrist]

I have code

Set nms = ActiveWorkbook.Names
For Each c In nms

and get a c.name="'Sheet4'!_Regression_Int"

Note that this means it's a "sheet-local" defined name. _Regression_Int isn't even in google, which signifies Armageddon, AFAIC. Other ones are
"'Sheet4'!ALR"
"'Sheet4'!ALRN"
"'Sheet4'!ANTLRN"

I'm assuming that these are not part of Excel; thus a prior user must have created them. I'd like to strip them out. Apparently they're unused.

However they're not in (insert/names/define) list - even though Sheet4 is active. I can't even see them, much less delete them. What am I missing here?

** EDIT 9-28-06: ALR, ALRN and ANTLRN are in fact in the define list, but not _Regression_Int. My bad **

 

[HalfAce]

Hi Gates,
Try this on a blank sheet and see if it tells you where the range(s) is/are.

[a1].ListNames

Any ranges not desired should be able to be deleted with more code. (And I guess you don't
really need to know where they are for that if you know their names.

 

[Gates Is Antichrist]

Thanks for the suggestion. No, they're not in [a1].ListNames.

Sure, I can terminate them from the code (although, not exactly effortlessly) ... but I still don't get what's going on here. They're little mysterious Underwear Gnomes that only appear when you're not looking. I wish I knew how they got there, and where are they seen in the Excel non-VBA interface.

 

[HalfAce]

They don't get listed when you run that bit of code?

 

[Gates Is Antichrist]

Foolish me - half foolish anyway. I actually did go to a blank sheet (thank you for the thoughtfulness, since A1:B?? gets overwritten ). Local defined ranges would be invisible there anyway.

But if I actually go to Sheet4, _Regression_Int is not found by either .Listnames or alt-I/N/D. Maybe the leading underscore means it's an internal variable?