RefersToR1C1 Property

Applies To

Name Object.

Description

Returns or sets a string containing the formula that the name is defined to refer to, in R1C1-style notation, in the language of the macro writer, beginning with an equal sign. Read-write.

See Also

RefersTo Property, RefersToLocal Property, RefersToR1C1Local Property, RefersToRange Property.

Example

This example creates a new worksheet and then inserts a list of all names in the active workbook, including their formulas in R1C1-style notation in the language of the macro.

Set newSheet = ActiveWorkbook.Worksheets.Add
i = 1
For Each nm In ActiveWorkbook.Names
    newSheet.Cells(i, 1).Value = nm.Name
    newSheet.Cells(i, 2).Value = "'" & nm.RefersToR1C1
    i = i + 1
Next