Copy Function Question
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
|