thank you very much for the help.. works like a charm!

Now i have one final question. Is there a way to make a range that has
columns missing?

For example, I would like the data in Columns A,B,F thru O, Q,R

since there are some columns on the origional sheet that i do not want
to copy and paste to the new worksheet.


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