Spanish/English Formulas
 

I'm writing a code that inputs a formula in a cell.

How can I get it so the formula is readable either in English and Spanish
versions of Excel?. i.e. '=SUM(A1,B1)' and '=SUMAR(A1;B1)', please note the
different separations ',' and ';'.

Thanks!

Spanish/English Formulas
 

Hi econcult

If you insert it with VBA you can use the English formulas and seperator

ActiveCell.Formula = "=SUM(A1,B1)"

On a Spanish machine it will be =SUMAR(A1;B1) in the cell

Only you can't use the ATP functions this way

--
Regards Ron de Bruin
http://www.rondebruin.nl



"econcult" wrote in message ...
I'm writing a code that inputs a formula in a cell.

How can I get it so the formula is readable either in English and Spanish
versions of Excel?. i.e. '=SUM(A1,B1)' and '=SUMAR(A1;B1)', please note the
different separations ',' and ';'.

Thanks!