Name Object and the Names Collection

The Names collection holds the list of named ranges in a workbook. Each Name object describes a range of cells in a workbook that can be accessed by the name. Some Name objects are built-in (for example, Print_Area) and others are user-defined. The parent of the Names collection can be the WorkBook, Application, or Worksheet object. The Name object can also be accessed through the Range object.

The Names collection has an Add method besides the typical collection attributes. The Add method adds a Name object to the collection. The parameters of the Add method correspond to the properties of the Name object.

0 0

Post a comment