Cell name

  • Thread starter Thread starter ranswert
  • Start date Start date
R

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
 
msgbox Activecell.Name.Name

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

Jim Thomlinson said:
msgbox Activecell.Name.Name

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