Use Pastespecial instead of paste this gives you the option to paste all. You
can pastespecial a second time for column widths for example.

Mike

"dmk" wrote:

I am trying to copy a worksheet from one file to another. How do I keep the
formatting the same?