Spanish/English Formulas

[econcult]

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!

[Ron de Bruin]

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" <econcult@discussions.microsoft.com> wrote in message news:5751C05A-07CC-4DEA-A24F-D5BA008A909E@microsoft.com...
> 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!