[SOLVED]Macro to create new worksheets

[signgain82]

Hello,

I'm trying to figure out how to create a Macro that will create a new worksheet at the very end of all the current sheets. I want the macro to first come up with an InputBox, and whatever the user types into that Input box will be the new name of the Worksheet. I also want this worksheet to be identical to the Template worksheet I already have in the Workbook.

I thought this would be easy to code but I'm having some trouble of course

Here is what I have so far:

Please Login or Register  to view this content.

If I delete the bottom 4 Lines, it will create a new blank worksheet named after what I input into the InputBox. I just cannot seem to get it to copy the Template worksheet and Paste it into the newly created worksheet. Any help, as always, would be greatly appreciated!

ALSO: If there is a way to have an error message, or just have the macro stop if the user enters something that cannot be a worksheet name, that would be extra awesome

Thanks!

[JapanDave]

Hey , Is this what you are after?

Please Login or Register  to view this content.

[signgain82]

This works perfectly and is 10x cleaner than my attempt, I have a lot to learn! Thank you so much, +rep!

[JapanDave]

Thanks. Don't worry , I also still have a lot to learn myself.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.