Hi All,

Can anyone help me out with some vba which:

-Duplicates the current sheet
-User input box which asks for the new sheet's name
-Maintains formulas and sheet references, though when any formula on the current sheet call's for a reference to another sheet, that reference is replaced with value

Is there an easy way to go about doing this?