title: Excel 2010 VBA Error 1004 with formula
body: <p>I have this code:</p>
  
  <pre><code>Dim fStrecke As String
  fStrecke = "=A" &amp; z &amp; "*B" &amp; z &amp; "*C" &amp; z
  wks.Cells(z, "L").Formula = fStrecke
  
  Dim fZeit As String
  fZeit = "=IF(ISBLANK(H" &amp; z &amp; ");((A" &amp; z &amp; "*B" &amp; z &amp; "*I" &amp; z &amp; ")-I" &amp; z &amp; ")+(A" &amp; z &amp; "*B" &amp; z &amp; "*J" &amp; z &amp; ");(A" &amp; z &amp; "*B" &amp; z &amp; "*H" &amp; z &amp; "))"
  wks.Cells(z, "K").Formula = fZeit
  </code></pre>
  
  <p>The first formula is working and for the second i get an runtime error 1004. any idea? i have formatted the column K as user defined with "m:ss".</p>