Application.Sheets property (Excel)
Returns a Sheets collection that represents all the sheets in the active workbook. Read-only Sheets object.
expression.Sheets
expression An expression that returns an Application object.
Using this property without an object qualifier is equivalent to using ActiveWorkbook.Sheets.
This example creates a new worksheet, and then places a list of the active workbook's sheet names in the first column.
VB
Set newSheet = Sheets.Add(Type:=xlWorksheet)
For i = 1 To Sheets.Count
newSheet.Cells(i, 1).Value = Sheets(i).Name
Next i
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.