New Sheet Macro

[gyckl]

Hi
I'm building a pricing model and need a macro that the user can run once they have completed the first form. I need them to click an object that runs and creates a new sheet of the exact copy of the last sheet they have just completed.
Does anybody know the code that I can enter that will make this happen?
Any help much appreciated!
Cheers

 

[VoG]

Try

Sub AddSheet()
ActiveSheet.Copy after:=ActiveSheet
End Sub