Cell name
 

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

Cell name
 

msgbox Activecell.Name.Name

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

Jim Thomlinson


"ranswert" wrote:

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

Cell name
 

worked great
Thank You

"Jim Thomlinson" wrote:

msgbox Activecell.Name.Name

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

Jim Thomlinson


"ranswert" wrote:

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