• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 634
  • Last Modified:

Excel VBA Check if a cell is named

Hi

What Excel VBA would I use to check if a single cell is also a named range?
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

Sub macro()
On Error Resume Next
Set cellName = ActiveCell.Name
On Error GoTo 0
If Not IsEmpty(cellName) Then
    MsgBox "ActiveCell has name: " & cellName.Name
End If
End Sub

Open in new window

Regards
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now