Sheets Collection

Multiple objects
Sheets
Workbook

A collection of all the Worksheet objects in the workbook. Each Worksheet object represents a worksheet.

Using the Sheets collection

The following properties return a Sheets collection.

The Spreadsheet object's Sheets property.

The Window object's SelectedSheets property.

The Workbook object's Sheets property.

Properties | Application Property | Count Property | Item Property | Parent Property | Visible Property

Methods | Add Method | Copy Method | Delete Method | Move Method | Select Method

Parent Objects | ISpreadsheet Object | Spreadsheet Object | Window Object | Workbook Object

Child Objects | Workbook Object