Gets or sets a cell range to which the defined name refers.
Use the Range property to obtain an object that specifies a cell range associated with the defined name. If a defined name refers to a formula or constant, the Range property returns null (Nothing in VB). If a defined name refers to a relative range, the Range property gets a cell range relative to the A1 cell. For more information on defined names, see the Defined Names document.