If I want to get the named cell,
For instance D5 is mycell1
If I have
Dim objRange As Excel.Range
Set objRange = Range("D5")

Can I get the name of the cell?

If I do this:
objRange.ListNames
it puts the name of the cell in the text area. Quite strange.
But, any way to get the named cell?
thanks