Yes, the macro can be made to copy the formatting.

Post the macro, and what formatting you want copied (ie, range of cells).

--
Regards,
Fred


"Maggie" wrote in message
ups.com...
I have a button that I press on one worksheet that will copy and
insert another worksheet. The only problem is that once I hit that
button, the formatting does not follow. Is there a way that I can
make the macro do this?