Sheets.Add (Excel)

Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet. For examples see: Create a new worksheet using VBA

If Before and After are both omitted, the new sheet is inserted before the active sheet.

Add (Before, After, Count, Type)

ActiveWorkbook.Sheets.Add Before:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count)


Optional arguments

The following arguments are optional

Before (Chart) - An object that specifies the sheet before which the new sheet is added.

After (Chart) - An object that specifies the sheet after which the new sheet is added.

Count (Long) - The number of sheets to be added. The default value is the number of selected sheets.

Type (XlSheetType) - Specifies the sheet type. Can be one of the following XlSheetType constants: xlWorksheet, xlChart, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. If you are inserting a sheet based on an existing template, specify the path to the template. The default value is xlWorksheet.

Possible return values are xlChart - Chart, xlWorksheet - Worksheet.