Description
A collection of all the Module objects in the specified or active workbook.
Accessors
Use the Add method to create a new module and add it to the collection. The following example adds a new module before sheet one in the active workbook.
Modules.Add before:=Sheets(1)
Use the Modules method to 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 modules in the active workbook to the end of the workbook.
Modules.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 (Modules Collection), Copy Method, Delete Method, Item Method, Move Method, PrintOut Method, Select Method.