
This tutorial explains how to add new work sheets using Worksheets.Add Method in Excel VBA, or add new worksheets at the back or before specific worksheet
You may also want to read:
Excel VBA Worksheets.Copy Method to copy worksheet
Excel VBA Worksheets.Add Method to add new worksheet
Excel VBA Worksheets.Add Method is to add new worksheet in a workbook.
Syntax of Excel VBA Worksheets.Add Method
Worksheets.Add([Before],[After],[Count],[Type])
Before
Optional. Add new worksheet ...
Read More