Hi I have hunce that you are setting the Cell.Value = "=SUM
($A$1:$R$1)" but you really want to be setting the
Cell.Formula="=SUM($A$1:$R$1)" your users in France and
any where else in the world would see there respective
locale function. The reason is that if you create a
summation via the menu and then save the file, close Excel
and change your regional settings and then reopen the file
you'll see the formula has changed its name, try English
to French to see Sum change to Somme or to German Summe.

Hope this help
regards
KM

-----Original Message-----
Here is my problem:
I am trying to write a formula in a workbook using VB.
Unfortunatly, my users are from 5 different country, so I
can't just write "=SUM($A$1:$R$1)", in other language the
sum formulas simply do not exist...

Ex:The "SUM" function is "Somme" in french

I do not want to make selection depending on which
langage the user have on Excel... there must be a way to
call those formulas with a Tag, an ID or something...

Anybody got an idea???

Many thank!
.