Get ActiveCell Name in VBA

[BAlGaInTl]

Ok...

I'm actually working on another problem, and I thought I had the solution...

Let's say that I have named range A1 something like "Name01" for easy access in formulas.

Is there any way to return that Value by VBA?

If I use:

ActiveCell.Name or Selection.Name, I get the full "=Sheet1!$A$1" instead.

Any thoughts are appreciated.

 

[Colin Legg]

Like this, for example?

Debug.Print Range("Name01").Name.Name

 

[BAlGaInTl]

Like this, for example?

Debug.Print Range("Name01").Name.Name

Thanks...

It never occured to me to use .Name.Name

That seems a bit counterintuitive...

Perfect.

:D

 

[Colin Legg]

Glad to help. Yes, it looks a little odd, but the range object's name property returns a Name Object. The Name Object also has a name property, which is what we use to get its name.

HTH,
Colin