Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs.
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:
Microsoft Certified Partners -
https://partner.microsoft.com/global/30000104Microsoft Advisory Services -
http://support.microsoft.com/gp/advisoryserviceFor more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMSSample Visual Basic Procedure
To retrieve the defined name that has been applied to a range of cells, you
must use the
Name property of the
Name object.
The following Visual Basic for Applications procedure assigns the
defined name of a cell to a variable and displays this name in a message
box:
Sub ShowName()
Dim Cell_Name As String
Cell_Name = ActiveCell.Name.Name
MsgBox Cell_Name
End Sub