Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
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 **
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 **