Single letters such as A and B are OK, but C and R are forbidden, presumably
because of potential confusion with RC row & column designation.
--
David Biddulph


"art" wrote in message
...
I found out the problem. I wanted to name a cell with a letter like "c".
Somehow Excel does not let you name a cell with one letter. I don't know
why.
Any explanation?

"Jon Peltier" wrote:

Sometimes it seems like it didn't work, if you give a cell a name, then
give
it another name, sometimes the original name appears in the name box,
even
though the cell now answers to both. Also I know sometimes I get moving
too
quickly and forget to hit Enter after typing the name in the name box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"art" wrote in message
...
Thanks, I tried it once, and I don't know why it didn't go, I tried it
now
it
works. Thanks.

"Dave Peterson" wrote:

Yep. You'll see when you do it. You can actually give a single cell
lots of
different names.

art wrote:

Is there a way to name a range let's say A1:B10 we'll call "team"
and
A5 I
want to name "coach", is that possible to name the cell even though
it
is in
a named in a range?

--

Dave Peterson