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

Stop using the queries????

It looks like these are names that the queries use.

If you work with names a lot, do yourself a favor and get this addin:

Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager.

http://www.jkp-ads.com/Download.htm

Life will be a lot nicer!

===
I'm not sure what the code was and why it didn't work for you.

Meme wrote:

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

--

Dave Peterson