title: When trying to paste using FormulaR1C1 in excel macro, cell is filled empty
body: <p>I used &quot;record macro&quot; to get the following formula. when I try to paste them back into the cells, they are not working. no formula gets inserted into the cells</p>
  <p>my formula as follows</p>
  <pre><code>Dim schedsheet as Worksheet
  Set schedsheet = Sheets(&quot;Sheet1&quot;)
  schedstartrow = 15
  schedendrow = 134
  schedsheet.Range(&quot;Q&quot; &amp; schedstartrow, &quot;Q&quot; &amp; schedendrow).FormulaR1C1 = _
      &quot;=IF(RC[-13]=&quot;&quot;DES&quot;&quot;,&quot;&quot;&quot;&quot;,IFERROR(INDEX(C67,MATCH(SUMIFS(C63,C66,RC[25],C65,RC[-9]),C63,0)),&quot;&quot;&quot;&quot;))&quot;
  schedsheet.Range(&quot;T&quot; &amp; schedstartrow, &quot;T&quot; &amp; schedendrow).FormulaR1C1 = &quot;=IFERROR(INDEX(R[1]C9:R[1000]C9,MATCH(RC[-10],R[1]C[-10]:R[1000]C[-10],0)),&quot;&quot;&quot;&quot;)&quot;
  
  </code></pre>