OldSheet = "Sheet1"
Worksheets(OldSheet).Copy after:=Sheets(Sheets.Count)
Set Newsht = ActiveSheet
Newsht.Name = "Joel"

"mitch" wrote:

I've got a userform created with a textbox, an apply button and a cancel
button. If OK is clicked, i want the macro to duplicate a specific named
worksheet (say template) and rename the duplicate to the value in the textbox.

This doesn't seem to be terrible difficult, but I'm having problems. Any
advice?