Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.
expression.Add (Before, After, Count, Type)
expression A variable that represents a Worksheets object.
|Before||Optional||Variant||An object that specifies the sheet before which the new sheet is added.|
|After||Optional||Variant||An object that specifies the sheet after which the new sheet is added.|
|Count||Optional||Variant||The number of sheets to be added. The default value is one.|
|Type||Optional||Variant||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.|
An Object value that represents the new worksheet, chart, or macro sheet.
If Before and After are both omitted, the new sheet is inserted before the active sheet.