Worksheet Object and the Worksheets Collection

The Worksheets collection holds the collection of worksheets in a workbook. The Workbook object is always the parent of the Worksheets collection. The Worksheets collection only holds the worksheets. The Worksheet objects in the Worksheets collection can be accessed using the Item property. The name of the worksheet can be specified as either a parameter to the Item's parameter or an index number describing the position of the worksheet in the workbook (from left to right).

The Worksheet object allows access to all of the attributes of a specific worksheet in Excel. This includes worksheet formatting and other worksheet properties. The Worksheet object also exposes events that can be used programmatically.

The Worksheets collection has a few properties and methods besides the typical collection attributes. These are listed in the following table.

0 0

Post a comment