When working with formula's in Excel using automation, you have to know what language-version of Excel is installed (English, Dutch, French, etc.) in order to write your formula (eg. SUM/SOM/SOMME, ROUND/AFRONDEN/...).
(with lxlCountryCode = 1) returns the language being used.
There must be a way to use formula's independant of the language, so you only have to write them in English.
How can you do this?