One way:


Sub dk()
MsgBox ActiveCell.Name.Name
End Sub


"James Price at Premier"
wrote in message ...
I have a worksheet which has a number of Range names. Each named range
relates to one cell only. There will be no instances of more than one
range
name in a cell. Can I use VBA to check if the Active Cell has a range
name
in it.

Many thanks

James