Cell name

[ranswert]

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

 

[Jim Thomlinson]

msgbox Activecell.Name.Name

There is a bit of an explanation that goes this that but suffice it to say
this work...

 

[ranswert]

worked great
Thank You

msgbox Activecell.Name.Name

There is a bit of an explanation that goes this that but suffice it to say
this work...