Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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