Add a New WorkSheet in Excel – VBA Macro Code
This VBA code will add a new worksheet in your Excel project.
Sub AddNewWorksheet() Dim NewWorkSheet As Worksheet Set NewWorkSheet = Sheets.Add End Sub
Posted by Excel Instructor:
http://www.chicagocomputerclasses.com/excel-classes/