Spanish/English Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to translate Excel formula function name to another language? 1
Translating English-Spanish on cells 2
Scrabble Value calculation for Welsh words 0
A data validation question 1
Time Calculations Help 4
Naming non-contigent cells with vba 5
Concantenate which keeps bold of some parts. 5
Converting excel currently in english to spanish 6

Back
Top