Workbook.Sheets (Excel)

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

Using this property without an object qualifier is equivalent to using ActiveWorkbook.Sheets.


Dim shtsSheets As Sheets
Set shtsSheets = ActiveWorkbook.Sheets