Worksheets collection object

You can also refer to collections of objects. A collection is a group of objects of the same kind. A collection has the plural form of the object s name (e.g.. Worksheets). Worksheets refers to all worksheets in a particular workbook. To reference a particular worksheet, you use the reference Worksheets(A/amerext) for example, Worksheets("Spectrum1"). 

To distinguish a particular collection of worksheets in a particular workbook, use the period operator to connect object names. For example, to refer to the Worksheet Spectrum 1 in the Workbook Deconvolution, use the reference Workbooks( "Deconvolution").Worksheets("Spectrum1"). To refer to a particular cell within the worksheet, use... 

An object can contain many other objects, e.g., a worksheet can consist of several ranges and charts the ranges can have many arrays, which in turn can include a multitude of cells the charts likewise can contain many objects such as axes, curves, labels, etc. Fikewise, a group of objects can form a collection, which it itself an object. Consequently there is a whole hierarchy of objects, from the more all-inclusive to the more specific, and VBA describes all specific objects by enumerating the entire hierarchy, from the general to the particular, separated by periods, as in... 

---