Deletion of Range Names

[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

 

[Frank Kabel]

Hi
try using the Name-Manager add-in: www.decisionmodels.com

 

[Karl]

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

 

[Bruce Sinclair]

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

[/QUOTE]

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

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)

 

[Karl]

MICROSOFT - the name says it all

 

[Dave Peterson]

And why do you have to click the Start button to shut down???