Name.RefersToRange Property (Excel)
Returns the Range object referred to by a Name object. Read-only.
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.
This example displays the number of rows and columns in the print area on the active worksheet.
Ensure that you establish a print area on the active sheet of the current workbook.