Thanks alot Dianne. Seems to work great. Yeah, there are three blan
columns which can be taken out and then re-added later. The onl
criteria is each worksheet needs three blank colums inserted after th
"E" column. I can delete the three columns beforehand. Do you kno
the code to do this, or could you put that mod. in my code for me?

Thanks a million - you saved me a great deal of hand labor.

-Mik

--
Message posted from http://www.ExcelForum.com