Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Invalid define names
What are invalid letter combo's for Insert/Name/Define Excel 2003.
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
one or more invalid names were detected in this work sheet | Excel Discussion (Misc queries) | |||
Invalid Names | Links and Linking in Excel | |||
Define Names in Excel | Excel Discussion (Misc queries) | |||
alternate UI for Define Names ?? | Excel Discussion (Misc queries) | |||
Invalid Range Names | Excel Discussion (Misc queries) |