Worksheets Property

         Example         Applies To

Application object: Returns a Sheets collection that represents all the worksheets in the active workbook. Read-only.

Workbook object: Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only.

For information about returning a single member of a collection, see Returning an Object from a Collection.

Remarks

Using this property without an object qualifier returns all the worksheets in the active workbook.

This property doesn’t return macro sheets; use the Excel4MacroSheets property or the Excel4IntlMacroSheets property to return those sheets.