Cell name
 

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?

Cell name
 

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?

Cell name
 

ooooooooooooohhhhhhhhh. Man that was driving me crazy..
Thanks so much for the help, it works great.

"K Dales" wrote:

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?