I have the following code:
dim a as string
a = ActiveCell.name
MsgBox (a)

I want to get the name of a cell that I have given it. What I get is:

=sheet1!$E$11

instead of the name I have given it.

How do I correct this?
Thanks