title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Sheets.Add method (Excel) |
vbaxl10.chm152073 |
|
|
db5de750-fd09-2b18-c52b-98d88eeb0ffc |
09/03/2019 |
medium |
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 Sheets object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
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 the number of selected sheets. |
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.
This example inserts a new worksheet before the last worksheet in the active workbook.
ActiveWorkbook.Sheets.Add Before:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count)
This example inserts a new worksheet after the last worksheet in the active workbook, and captures the returned object reference in a local variable.
Dim sheet As Worksheet
Set sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count))
Note
In 32-bit Excel 2010, this method cannot create more than 255 sheets at one time.
[!includeSupport and feedback]