Name.RefersToRange (Excel)

Returns the Range object referred to by a Name object.

If the Name object doesn't refer to a range (for example, if it refers to a constant or a formula), this property fails. To change the range that a name refers to, use the RefersTo property.

Dim rngRefersToRange As Range
Set rngRefersToRange = ActiveWorkbook.Names(1).RefersToRange