checking if a range has a name.

[Peter]

Hello everyone,

Let's say I have given the name "automobile" to cell B7.
If that cell is selected at a certain moment, is is possible to retrieve the
name "automobile" that has been given to it?

I'd like to do something along the lines of (free styling) :
if the name of the active cell =
"automobile" then .... etc. etc.

Does anyone have code for this kind of thing?

Thanks,
Peter

 

[Dave Peterson]

Maybe:

Option Explicit
Sub testme()

Dim myName As String
myName = ""
On Error Resume Next
myName = ActiveCell.Name.Name
On Error GoTo 0

If myName = "" Then
MsgBox "no name"
Else
MsgBox "It's: " & myName
End If
End Sub