Workbooks 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... 

---

See also in sourсe #XX -- [ ]

---