VBA to copy a worksheet to another worksheet in the same work Book

[Macca_GB]

Hello, is there a single line of code that will allow me to copy the contents, formats as well, from one worksheet to another within the same workbook?

Thanks in advance.

[ranman256]

Hit Record Macro. Then make the copy. Stop macro.
Then edit the code how you want.

[sktneer]

You may try this.....

Please Login or Register  to view this content.