How to: Add New Worksheets to Workbooks

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

You can programmatically add a new worksheet to the collection of worksheets in the workbook.

To add a new worksheet to a workbook in a document-level customization

  • Use the Add(Object, Object, Object, Object) method of the Sheets collection.

    Dim newWorksheet As Excel.Worksheet
    newWorksheet = CType(Globals.ThisWorkbook.Worksheets.Add(), Excel.Worksheet)
    Excel.Worksheet newWorksheet;
    newWorksheet = (Excel.Worksheet)Globals.ThisWorkbook.Worksheets.Add(
        missing, missing, missing, missing);

    The new worksheet is a native Worksheet object and not a host item. If you want to add a Microsoft.Office.Tools.Excel.Worksheet host item, you should add the worksheet at design time.

To add a new worksheet to a workbook in an application-level add-in

See Also


How to: Delete Worksheets from Workbooks

How to: Select Worksheets


Working with Worksheets

Host Items and Host Controls Overview

Global Access to Objects in Visual Studio Tools for Office Projects

The Variable missing and Optional Parameters in Office Solutions

Other Resources

Excel Host Controls

Change History




July 2008

Added a code example that can be used in an application-level add-in.

Customer feedback.