Worksheets.Add Method

  • Article

Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Add ( _
    Before As Object, _
    After As Object, _
    Count As Object, _
    Type As Object _
) As Object
'Usage
Dim instance As Worksheets
Dim Before As Object
Dim After As Object
Dim Count As Object
Dim Type As Object
Dim returnValue As Object

returnValue = instance.Add(Before, After, _
    Count, Type)

Object Add(
    Object Before,
    Object After,
    Object Count,
    Object Type
)

Parameters

  • Before
    Type: System.Object

    Optional Object. An object that specifies the sheet before which the new sheet is added.

  • After
    Type: System.Object

    Optional Object. An object that specifies the sheet after which the new sheet is added.

  • Count
    Type: System.Object

    Optional Object. The number of sheets to be added. The default value is one

  • Type
    Type: System.Object

    Optional Object. 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.

Return Value

Type: System.Object

Remarks

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

See Also

Reference

Worksheets Interface

Worksheets Members

Microsoft.Office.Interop.Excel Namespace