title: International macros in Excel
body: <p>I'm trying to create an international Excel macro sheet.
  These macros should work for many countries</p>
  
  <p>I'm writing formulas in English using <code>Range.formula</code>, but it does not work for all formulas (?)</p>
  
  <p>For example, I create </p>
  
  <pre><code>Range("D4").Formula = "=SUM(D7:D14)"
  </code></pre>
  
  <p>In Spanish Excel it works so is filled with "<code>=SUMA(D7:D14)</code>". Is correct</p>
  
  <p>Other formulas fails, for example: </p>
  
  <pre><code>"=IF(R2=8;D7;D6)"                  'In Spanish Excel I get error 1004
  
  "=ISNUMBER(O2)" works =ESNUMERO(O2)
  
  "=PRODUCT(O2;O3)" Does not work,  error 1004  
  </code></pre>
  
  <p>I'm with Excel 2010 and Windows 7 , and I cannot understand this strange behavior. Parameters are valid for all formulas</p>
  
  <p>Any ideas?</p>