Description
A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet, a Microsoft Excel version 4.0 macro sheet, or a Microsoft Excel version 4.0 international macro sheet.
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 the Worksheets method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example moves all the worksheets to the end of the workbook.
Worksheets.Move after:=Sheets(Sheets.Count)
The Sheets collection contains all of the sheets in the workbook (chart sheets, dialog sheets, modules, and worksheets). Use the Sheets method with an argument to access a single member of the collection or without an argument to access the entire collection at once.
Properties
Application Property, Count Property, Creator Property, Parent Property, Visible Property.
Methods
Add Method (Worksheets Collection), Copy Method, Delete Method, FillAcrossSheets Method, Item Method, Move Method, PrintOut Method, PrintPreview Method, Select Method.