Microsoft KB Archive/25691

{| = Excel: Returning Contents of Refers To Box for Defined Name =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q25691

SUMMARY
By using the GET.NAME function, a Microsoft Excel macro can return the contents of the Refers To box in the Define Name dialog box for the desired name. This reference will be returned as a text string.

For example, use the following macro command to return the contents of the Refers To box

=MID(GET.NAME("!defname"),2,LEN(GET.NAME("!defname"))) where "defname" is the name that is defined on the active worksheet. Note that the text string will be returned in RC notation without an equal sign (=).
 * }