ActiveCell.Name.Name
(yeah, weird but that's the way it goes!)
--
- K Dales


"Kevin" wrote:

If I name cell A1 "blah".
and then select that cell.
I need a macro to make activecell.offset(1,0)=activell.name.

When I do it like this it returns the range name not the name I assigned to
A1.

Any suggestions?