Sheets Property

Applies To

Application object, Workbook object.

Description

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

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

Remarks

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

See Also

Charts property, Worksheets property.

Example

This example creates a new worksheet and then places a list of the active workbook's sheet names in the first column.

Set newSheet = Sheets.Add(Type:=xlWorksheet)
For i = 1 To Sheets.Count
    newSheet.Cells(i, 1).Value = Sheets(i).Name
Next i