T-Rex,

Thanks a million. It worked fine. I did have to figure out that in
order for it to work I had to save the originals as txt files, then
open them, and save them as xls files, then put the macro in place and
run it. I must have had some kind of format on the columns... that's
all I can think of... that screwed it up and caused the error.

Thanks again, worked like a charm! That will enable me to finish my
work up very very quickly!!!

Bill Beecham


--
billbeecham
------------------------------------------------------------------------
billbeecham's Profile: http://www.excelforum.com/member.php...o&userid=16286
View this thread: http://www.excelforum.com/showthread...hreadid=398686