identify the name of the activecell not its address
 

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

identify the name of the activecell not its address
 

Dim MyVariable as String
MyVariable = ActiveCell.Name.Name
HTH Otto
"RogerTheDodgerTheDirtyOldSod"
t.com wrote in message
...
i need to assign the range name of the acivecell to a variable - How!!

identify the name of the activecell not its address
 

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).

--
Regards,
Tom Ogilvy

"RogerTheDodgerTheDirtyOldSod"
t.com wrote in message
...
i need to assign the range name of the acivecell to a variable - How!!