Hi all,

I've posted this question the other day and someone gave
a piece of code to delete the names . But somehow the
code can not delete the names. Here is my problem again:
I have a workbook contains worksheet A , B ,and C.
My macro transfering data from several .prn files to
sheet B , then do some query and copy-paste the results
to sheet C. While in the middle of running the macro, it
created tens of names like "externaldata-
23", ..."externalnata_40". My question is how can I get
rid of those names ???
Please help!
By the way , anyone know how to avoid creating all these
unnecessary names ???

Thanks so much in advance
Meme