Hello everyone. I'm trying to get a button in excel 2007 that would basically create a duplicate of Sheet1 into Sheet2.

I've looked around the forum and found this code:

Dim NewSht As Worksheet
Set NewSht = Sheets.Add
    NewSht.Move After:=Sheets(Sheets.Count)

    With Sheets("Sheet1")
        .Range("A1").CurrentRegion.Copy Destination:=NewSht.Range("A1")
    End With
But what I'd additionally like to achieve is naming the Sheet2 as ie. Warehouse 2 (and Sheet1 is called, say Warehouse 1) in the process. Is that possible?