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)
Arguments
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.