Simply declare Befo
ActiveSheet.Copy Befo=Sheets("Paste")
ActiveSheet.Name = "format"

HTH

Die_Another_Day
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