Invalid range name in German version of Excel

[witek]

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.

 

[Ron de Bruin]

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

 

[Ron de Bruin]

To avoid problems always start with two letters like
SS1Mod

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

 

[witek]

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.

 

[Howard31]

Or put an underscore like S_1Mod or _S1Mod

 

[Ron de Bruin]

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