|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
How to: Add New Worksheets to Workbooks
Some code examples in this topic use the this or Me keyword or the
Themethod enables you to add a new worksheet to the collection of worksheets in the workbook. However, when you add the worksheet programmatically, the new worksheet is a native object that contains native Excel objects without any data-binding capabilities, events, or code. If you want to add a host item, you should add the worksheet at design time. For more information, see .
You can also create a copy of an existing worksheet. For more information, see.
To add a new worksheet to a workbook
Use the Add method of thecollection: