Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Sheets Collection Object [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects
Sheets
Multiple objects

A collection of all the sheets in the specified or active workbook. The Sheets collection can contain Chart or Worksheet objects.

The Sheets collection is useful when you want to return sheets of any type. If you need to work with sheets of only one type, see the object topic for that sheet type.

Using the Sheets Collection

Use the Sheets property to return the Sheets collection. The following example prints all sheets in the active workbook.

Sheets.PrintOut
		

Use the Add method to create a new sheet and add it to the collection. The following example adds two chart sheets to the active workbook, placing them after sheet two in the workbook.

Sheets.Add type:=xlChart, count:=2, after:=Sheets(2)
		

Use Sheets(index), where index is the sheet name or index number, to return a single Chart or Worksheet object. The following example activates the sheet named "sheet1."

Sheets("sheet1").Activate
		

Use Sheets(array) to specify more than one sheet. The following example moves the sheets named "Sheet4" and "Sheet5" to the beginning of the workbook.

Sheets(Array("Sheet4", "Sheet5")).Move before:=Sheets(1)
		


Properties | Application Property | Count Property | Creator Property | HPageBreaks Property | Item Property | Parent Property | Visible Property | VPageBreaks Property

Methods | Add Method | Copy Method | Delete Method | FillAcrossSheets Method | Move Method | PrintOut Method | PrintPreview Method | Select Method



Show: