Activesheet.cells.copy _
destination:=worksheets("Format").range("a1")

=====
But you may want to just delete the current sheet named Format, and copy the
sheet????

Michael Vaughan wrote:

Hello Everyone,

I have VBA code that takes a sheet and copies it, and then formats it to
what I need. But, the copy method that I use, is copying it to a new book
with the same sheet name.

ActiveSheet.Copy

Is there a way to copy the contents into the same book but to a different
sheet name instead of copying it to a completely new book??
For example:

I want to copy the contents of sheet "paste" into sheet "format".

Thanks,

Mikey Vaughan

--

Dave Peterson