I have written a macro to copy the data from one sheet to another. It is working fine except that I have to manually format the columns in each copied sheet. Is there any way I can copy the formating alond with the data.

Sarita