Applies To
Name Object.
Description
Returns or sets a string containing the formula that the name is defined to refer to, in A1-style notation, in the language of the macro writer, beginning with an equal sign. Read-write.
See Also
Formula Property, RefersToLocal Property, RefersToR1C1 Property, RefersToR1C1Local Property, RefersToRange Property.
Example
This example creates a list of all the names in the active workbook, and it shows their formulas in A1-style notation in the language of the macro. The list appears on a new worksheet created by the example.
Set newSheet = Worksheets.Add i = 1 For Each nm In ActiveWorkbook.Names newSheet.Cells(i, 1).Value = nm.Name newSheet.Cells(i, 2).Value = "'" & nm.RefersTo i = i + 1 Next newSheet.Columns("A:B").AutoFit