Hello all,

I am new to the forum and entirely new to VBA. I have been working on a project and have managed to write a couple macros thus far, one that returns the current sheet name to a cell, and two that protect or unprotect all sheets in the workbook.

I am stuck on this macro now, and have been looking everywhere with no avail. What I need is just a simple macro to take the currently selected cell and create a new worksheet with that name (it is a string). I also need to paste a template into that new worksheet from a pre-existing sheet.

Any help would be greatly appreciated, this is my first post. I am using Excel 2010 by the way.

-Brett