Expand Minimize

Application.Sheets Property (Excel)

Published: July 16, 2012

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

expression .Sheets

expression An expression that returns a 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.

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

Community Additions

ADD
Show:
© 2014 Microsoft