Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Working with Worksheets to add a worksheet
Sub add()
    Dim mySheet As Worksheet
    Set mySheet = Workbooks(1).Sheets.Add(before:=Sheets(1))
    mySheet.Name = "Summary"
End Sub