identify the name of the activecell not its address

[Guest]

i need to assign the range name of the acivecell to a variable - How!!

 

[Otto Moehrbach]

Dim MyVariable as String
MyVariable = ActiveCell.Name.Name
HTH Otto
"RogerTheDodgerTheDirtyOldSod"

 

[Tom Ogilvy]

ActiveCell.Name.Name

if it doesn't have a name, this causes an error. (the cell itself must be
named, not this cell be part of a larger number of cells with a name).