Workbook.Worksheets (Excel)

Returns a Sheets collection that represents all the worksheets in the specified workbook.

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.

Dim shtsWorksheets As Sheets
Set shtsWorksheets = ActiveWorkbook.Worksheets