Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Creates a new workbook and adds it to the collection, reads the number of workbooks into a variable, and selects all worksheets in t
Sub workbookAdd()
    Workbooks.Add
    numWorkbooks = Workbooks.Count
    Worksheets.Select
End Sub