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?