I'd like to test is a cell has a name and if so, find out what that name is. The name to reflect the cell only (so not refer to more cells).
An example is probably a good thing... Some cells have a special purpose in my sheet; I am giving these (individual cells) a name, e.g. cell G3, when identified for the special purpose will have the name "Special_G3".
Now if the user is doing something with a cell, I need to test in VBA is that cell is special, so I'd like to find out if that cell has a name and if that name is "Special_G3" in this case (also, and obviously, "Special_G3" should only apply to ONE cell (G3))
I'm not sure how difficult this is, Range("G3").Name doesn't do the trick (that would have been too simple I guess )