Deletion of Range Names

M

mzitzow

There are some mystery named ranges in my workbook I want to kill.

However, they have non-alph/numberic characters in their name and won'
die.
The bad characters are square boxes: 

I have also tried deleting them through VB:
On Error Resume Next
Set nms = ActiveWorkbook.Names
For x = 1 To nms.Count
Debug.Print nms(x).Name
nms(x).Delete
Next x

But to no avail. Any ideas??
Thanks,
Mar
 
K

Karl

INSERT - NAMES - DEFINE should have a list of all of them delete the ones
you don't want
 
B

Bruce Sinclair

[QUOTE=""Karl said:
There are some mystery named ranges in my workbook I want to kill.

However, they have non-alph/numberic characters in their name and won't
die.
The bad characters are square boxes: 

I have also tried deleting them through VB:
On Error Resume Next
Set nms = ActiveWorkbook.Names
For x = 1 To nms.Count
Debug.Print nms(x).Name
nms(x).Delete
Next x

But to no avail. Any ideas??
Click to expand...
[/QUOTE]
INSERT - NAMES - DEFINE should have a list of all of them delete the ones
you don't want
Click to expand...

Anyone else find it odd that to delete names you have to insert them ? ...
and (AFAIK) you can only do this one at a time ?



Bruce

------------------------------
Health nuts are going to feel stupid someday, lying in hospitals dying of nothing.

-Redd Foxx


Caution ===== followups may have been changed to relevant groups
(if there were any)
 
Top