Excel.Application.Sheets.md

title	Application.Sheets property (Excel)
keywords	vbaxl10.chm132108
f1_keywords	vbaxl10.chm132108
api_name	Excel.Application.Sheets
ms.assetid	729a512a-8faa-3a7e-758b-ff76e7200662
ms.date	04/05/2019
ms.localizationpriority	medium

Application.Sheets property (Excel)

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

Syntax

expression.Sheets

expression An expression that returns an Application object.

Remarks

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

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

[!includeSupport and feedback]