Thread: Range Names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Range Names

Sub DelAllNames()
Dim nm As Name
For Each nm In ActiveWorkbook.Names
nm.Delete
Next
End Sub

Regards,
Peter T

"Glenn" wrote in message
...
I need a simple way to delete all range names from a source file that I
process. I have no control over the source file. The file has a
bajillion
defined names that I'd like to not even know what they are, just delete
all.
Must I do them individually, or....