Invalid define names
 

What are invalid letter combo's for Insert/Name/Define Excel 2003.

Invalid define names
 

You can use letters, numerals, a few punctuation marks (. and _), but
nothing that looks like an operator (+ - * /). It must begin with a letter
(or maybe an underscore), and it must not be confused with a cell address,
like A1, B2, etc.

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


"Noreaster" wrote in message
...
What are invalid letter combo's for Insert/Name/Define Excel 2003.

Invalid define names
 

That would explain why AC1147 wouldn't work but QM1147 did. You have a good
informative website, I had help to transpose your chart.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Thank you very much.


"Jon Peltier" wrote:

You can use letters, numerals, a few punctuation marks (. and _), but
nothing that looks like an operator (+ - * /). It must begin with a letter
(or maybe an underscore), and it must not be confused with a cell address,
like A1, B2, etc.

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


"Noreaster" wrote in message
...
What are invalid letter combo's for Insert/Name/Define Excel 2003.

Invalid define names
 

An additional confusion is that you can use the single letters A, B, D, E,
F, ..., P, Q, S, T, U, ..., Z as names, but you can't use C or R.. The
create names facility will change these to C_ and R_.
This is presumably because of potential confusion with Columm and Row
designation.
--
David Biddulph

"Jon Peltier" wrote in message
...
You can use letters, numerals, a few punctuation marks (. and _), but
nothing that looks like an operator (+ - * /). It must begin with a letter
(or maybe an underscore), and it must not be confused with a cell address,
like A1, B2, etc.

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


"Noreaster" wrote in message
...
What are invalid letter combo's for Insert/Name/Define Excel 2003.

Invalid define names
 

I can use 2 letters, underscore and 4-6 numbers exa. ac_1148, qm_1148, pm_1147.
Should the letters be in caps or is it just a preference?

"David Biddulph" wrote:

An additional confusion is that you can use the single letters A, B, D, E,
F, ..., P, Q, S, T, U, ..., Z as names, but you can't use C or R.. The
create names facility will change these to C_ and R_.
This is presumably because of potential confusion with Columm and Row
designation.
--
David Biddulph

"Jon Peltier" wrote in message
...
You can use letters, numerals, a few punctuation marks (. and _), but
nothing that looks like an operator (+ - * /). It must begin with a letter
(or maybe an underscore), and it must not be confused with a cell address,
like A1, B2, etc.

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


"Noreaster" wrote in message
...
What are invalid letter combo's for Insert/Name/Define Excel 2003.

Invalid define names
 

However you like.

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


"Noreaster" wrote in message
...
I can use 2 letters, underscore and 4-6 numbers exa. ac_1148, qm_1148,
pm_1147.
Should the letters be in caps or is it just a preference?

"David Biddulph" wrote:

An additional confusion is that you can use the single letters A, B, D,
E,
F, ..., P, Q, S, T, U, ..., Z as names, but you can't use C or R.. The
create names facility will change these to C_ and R_.
This is presumably because of potential confusion with Columm and Row
designation.
--
David Biddulph

"Jon Peltier" wrote in message
...
You can use letters, numerals, a few punctuation marks (. and _), but
nothing that looks like an operator (+ - * /). It must begin with a
letter
(or maybe an underscore), and it must not be confused with a cell
address,
like A1, B2, etc.

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


"Noreaster" wrote in message
...
What are invalid letter combo's for Insert/Name/Define Excel 2003.

Invalid define names
 

Hi,

Far less known RC is also and illegal range name.

In 2003 A1-IV65536 are illegal because they are cell addresses, in 2007 this
is A1-XFD1048576 because of the larger spreadsheet.


--
Thanks,
Shane Devenshire


"Noreaster" wrote:

What are invalid letter combo's for Insert/Name/Define Excel 2003.