You can loop through the names collection and delete the offending names.
Not knowing anything about your created names, I can't tell you how to
differentiate which to keep and which to delete. As a worst case, you would
need a list of one or the other and check against that list.

--
Regards,
Tom Ogilvy

"latha" wrote in message
...
Can anyonetell me how to remove all the reference names (external_data_1)
in the sheet except my own created name references.
--
Soly