Coping sheet into another workbook

I am sure this is easy but I just don't know it.
What would the code be to copy a sheet from one workbook into a new, not yet opened, workbook?

Thanks for the help!

Hi there,

Try the following code:

Please Login or Register  to view this content.

Obviously you can replace "ActiveSheet" with any Worksheet Object you wish to copy.

Hope this helps,

Please let me know how you get on.

Regards,

Greg M

That will open a new workbook for me too and copy it to that newly opened book?

Hello,

Try it:

Please Login or Register  to view this content.

Indeed it will

Greg M