title: Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
body: <p>When I add data to my workbook it is necassary to copy the formula from an earlier cell to the new cell(s). </p>
  
  <p>I used the following formula to calculate my growth rate: </p>
  
  <pre><code>=WENN(ODER(K9="";L9="");"";WENNFEHLER((L9-K9)/K9;""))
  </code></pre>
  
  <p>Since this is very time consuming I want to improve it with a macro and have therefor written the following code: </p>
  
  <pre><code>Sub Growth()
  
  Tabelle3.Range("O9").Formula = "=WENN(ODER(K9="";L9="");"";WENNFEHLER((L9-K9)/K9;""))"
  
  Tabelle3.Range("O9:O14").FillDown
  
  
  End Sub
  </code></pre>
  
  <p>However, when I want to run the code "runtime error '1004': application defined or object defined error" occours for this line: </p>
  
  <pre><code>Tabelle3.Range("O9").Formula = "=WENN(ODER(K9="";L9="");"";WENNFEHLER((L9-K9)/K9;""))"
  </code></pre>
  
  <p>Does anyone know why this error occurs and how I can solve it? </p>