Copying a worksheet and pasting and setting the name

[KColgrove]

I have a code that copies the worksheet I want, but when it copies over it has "Name (2)". is there a way to make it so you can set the name of the workbook when you copy the previous one? I have this code, and I want to use value set to year2 as the worksheet name. I've tried ".Name = year2" but it comes back with an error.

Please Login or Register  to view this content.

[KColgrove]

I was able to solve this for myself, I will post what I did to anyone else who wants to solve this problem.

Please Login or Register  to view this content.

Since I knew the new sheet would be named Master (2) I went ahead and called that sheet and just renamed it using .Name