How to copy existing worksheet instead of moving values

[Xaos]

Hello,

I have a simple macro:

Please Login or Register  to view this content.

It works correctly, but can someone tell me how I can modify this to copy sheet1 (including formatting and pictures) to the output created sheets instead of just moving the values?

Any help appreciated

[fredlo2010]

Hi,

See if this helps

Please Login or Register  to view this content.

Thanks

[Xaos]

Thank you! That is almost perfect.

The only thing that wasn't perserved was the row and column sizes... any ideas on that?

[berlan]

Another alternative:

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

[Xaos]

Excellent.

Now I see what I was doing wrong. I was trying to set ws2 and copy in the same statement.

Thank you all for the help and Happy Holidays!