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

Sub AddNewWorksheet()

Dim NewWorkSheet As Worksheet

Set NewWorkSheet = Sheets.Add

End Sub

Add a New WorkSheet in Excel – VBA Macro Code