set sheet vba code example
Example: excel vba add sheet
Sheets.Add
Sheets.Add After:=Sheets("Input")
Sheets.Add After:=Sheets(1)
Sheets.Add Before:=Sheets(2)
Sheets.Add.Name = "NewSheet" ' Add sheet with name
Sheets.Add After:=Sheets(Sheets.Count) ' To end of Workbook
Sheets.Add(Before:=Sheets(1)).Name = "FirstSheet" ' To beginning of Workbook