Worksheets Collection Object

                  Properties         Methods        

A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

Using the Worksheets Collection

Use the Worksheets property to return the Worksheets collection.The following example moves all the worksheets to the end of the workbook.

Worksheets.Move after:=Sheets(Sheets.Count)

Use the Add method to create a new worksheet and add it to the collection. The following example adds two new worksheets before sheet one of the active workbook.

Worksheets.Add count:=2, before:=Sheets(1)

Use Worksheets(index), where index is the worksheet index number or name, to return a single Worksheet object. The following example hides worksheet one in the active workbook.

Worksheets(1).Visible = False

The Worksheet object is also a member of the Sheets collection. The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets).