Have you tried moving the cell?

--
Don Guillett
SalesAid Software

"Help Me" wrote in message
ups.com...
What is the easiest way to move the name of a cell
to another cell?

What I mean is: suppose the name "foobar" is associated
with C1, and now I want to associate "foobar" with C2
instead.

The intuitive method does now work for me [1]: click on
the new cell (C2), highlight then cell name in the Name
Box, and type "foobar". That goes to C1.

Currently, I must click on Insert / Name / Define,
highlight the name, and manually change the Refers To
reference.

[1] Excel 2002 (10.5815.6714) SP3