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

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

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