Add Method (Worksheets Collection) Example

This example creates a new worksheet and inserts it before the active sheet.

ActiveWorkbook.Worksheets.Add

This example adds a new worksheet after the last worksheet in the active workbook.

Worksheets.Add.Move after:=Worksheets(Worksheets.Count)