| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.de.excel,microsoft.public.excel.programming
|
|||
|
|||
Invalid range name in German version of Excel
Hi guys.
I try to name a range by putting name "S1Mod" there. It gives me a message that range name is invalid. The same happens when I try execute ActiveCell.Name = "S1Mod" It is an error in German version of Excel and in multi language version when language is set to German. It works fine with other version of Excel and with other languages. Excel 2003. What is a rule? S1xxxxx in not valid. K1xxxxxx is valid. |
|
#2
Posted to microsoft.public.de.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Invalid range name in German version of Excel
This is your problem
If you R1C1 reference style in your formulas you have problems if you have names like that In the English version you can't use r1mod (row) c1mod (column) In my Dutch version you can't use r1mod (rij) k1mod (kolom) In German it is S and ? I think You know now why you are not allowed to use this names -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "witek" wrote in message ... Hi guys. I try to name a range by putting name "S1Mod" there. It gives me a message that range name is invalid. The same happens when I try execute ActiveCell.Name = "S1Mod" It is an error in German version of Excel and in multi language version when language is set to German. It works fine with other version of Excel and with other languages. Excel 2003. What is a rule? S1xxxxx in not valid. K1xxxxxx is valid. |
|
#3
Posted to microsoft.public.de.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Invalid range name in German version of Excel
To avoid problems always start with two letters like
SS1Mod -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... This is your problem If you R1C1 reference style in your formulas you have problems if you have names like that In the English version you can't use r1mod (row) c1mod (column) In my Dutch version you can't use r1mod (rij) k1mod (kolom) In German it is S and ? I think You know now why you are not allowed to use this names -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "witek" wrote in message ... Hi guys. I try to name a range by putting name "S1Mod" there. It gives me a message that range name is invalid. The same happens when I try execute ActiveCell.Name = "S1Mod" It is an error in German version of Excel and in multi language version when language is set to German. It works fine with other version of Excel and with other languages. Excel 2003. What is a rule? S1xxxxx in not valid. K1xxxxxx is valid. |
|
#4
Posted to microsoft.public.de.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Invalid range name in German version of Excel
Ron de Bruin wrote:
This is your problem If you R1C1 reference style in your formulas you have problems if you have names like that In the English version you can't use r1mod (row) c1mod (column) In my Dutch version you can't use r1mod (rij) k1mod (kolom) In German it is S and ? I think You know now why you are not allowed to use this names That makes sense. Thanks a lot. You are best. |
|
#5
Posted to microsoft.public.excel.programming,microsoft.public.de.excel
|
|||
|
|||
|
Invalid range name in German version of Excel
Or put an underscore like S_1Mod or _S1Mod
-- A. Ch. Eirinberg "Ron de Bruin" wrote: To avoid problems always start with two letters like SS1Mod -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... This is your problem If you R1C1 reference style in your formulas you have problems if you have names like that In the English version you can't use r1mod (row) c1mod (column) In my Dutch version you can't use r1mod (rij) k1mod (kolom) In German it is S and ? I think You know now why you are not allowed to use this names -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "witek" wrote in message ... Hi guys. I try to name a range by putting name "S1Mod" there. It gives me a message that range name is invalid. The same happens when I try execute ActiveCell.Name = "S1Mod" It is an error in German version of Excel and in multi language version when language is set to German. It works fine with other version of Excel and with other languages. Excel 2003. What is a rule? S1xxxxx in not valid. K1xxxxxx is valid. |
|
#6
Posted to microsoft.public.excel.programming,microsoft.public.de.excel
|
|||
|
|||
|
Invalid range name in German version of Excel
Or put an underscore like S_1Mod or _S1Mod
Yes this are also two text characters before the number -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Howard31" wrote in message ... Or put an underscore like S_1Mod or _S1Mod -- A. Ch. Eirinberg "Ron de Bruin" wrote: To avoid problems always start with two letters like SS1Mod -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... This is your problem If you R1C1 reference style in your formulas you have problems if you have names like that In the English version you can't use r1mod (row) c1mod (column) In my Dutch version you can't use r1mod (rij) k1mod (kolom) In German it is S and ? I think You know now why you are not allowed to use this names -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "witek" wrote in message ... Hi guys. I try to name a range by putting name "S1Mod" there. It gives me a message that range name is invalid. The same happens when I try execute ActiveCell.Name = "S1Mod" It is an error in German version of Excel and in multi language version when language is set to German. It works fine with other version of Excel and with other languages. Excel 2003. What is a rule? S1xxxxx in not valid. K1xxxxxx is valid. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List Box not working when used in German Version of Excel | Excel Programming | |||
| Cannot access Excel created w/ German version of Excel | Excel Programming | |||
| Macros from German excel don't work with English version | Excel Programming | |||
| Problems with german excel version | Excel Programming | |||
| Problems with german excel version | Excel Programming | |||
Linear Mode
