Hello,
Im struggling abit.
I want to make a button where I add a new sheet with a specific name. In this example, "App1".
But I also want to copy a templatesheet to "App1".
So when I run this it should make a sheet named App1 with the template.
Im just missing the copy template line here,
If I simply run
Sheets("Template").Copy After:=Sheets(Sheets.Count)
it adds yet another Sheet, which it shouldnt.
Any ideas?
Please Login or Register to view this content.
Bookmarks