Bandicoot,
You have to assign a new name to the string/value being returned from the inputbox.
You also have to declare the dimension of that name ie:String or date etc.
Because you are adding the date to a string, it has to be a string. If you were adding the date to a seperate cell you could declare it as a date.
Sub MoveSheet()
Dim MySheetName, MyDate As String
Sheets("Template").Select
Sheets("Template").Copy Before:=Sheets(20)
MySheetName = InputBox("Please enter sheet name: ")
Sheets("Template (2)").Name = MySheetName
Sheets(MySheetName).Select
Sheets(MySheetName).Range("A1").Value = MySheetName
MyDate = InputBox("Please enter Date: ")
Sheets(MySheetName).Range("A2").Value = "Beginning from " & MyDate
End Sub
Bookmarks