Mega Code Archive
Categories
/
VisualBasic Script
/
Excel
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