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 user, beginning with an equal sign. Read-write.
See Also
RefersTo Property, RefersToLocal Property, RefersToR1C1 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 user.
Set newSheet = ActiveWorkbook.Worksheets.Add i = 1 For Each nm In ActiveWorkbook.Names newSheet.Cells(i, 1).Value = nm.NameLocal newSheet.Cells(i, 2).Value = "'" & nm.RefersToR1C1Local i = i + 1 Next