Hello Everyone,
I am trying to add a VB command to add a sheet in a workbook. I also need to populate the sheet with some info. I tried the following code, but it does not work. Any help would be great.
Sub InsertSheet ()
Sheets.Add
Sheets(“Sheet6”).Select
Sheets(“Sheet6”).Name = “Allotment”
Range(“A4”).Select
ActiveCell.FormulaR1C1 = “Date:”
Range(“A5”).Select
End Sub