title: Excel VBA: using R1C1 format, "Application defined or object defined error"
body: <p>I am trying to create a formula that references other cells, but I keep getting this "Application defined or object defined error". I use R1C1 convention instead of Offset. </p>
  
  <p>My Code:</p>
  
  <p><em>Note: This code could be anywhere, I just need it to work. Also, I don't use the code like this. It is used in a reporting tool, but this is just similar code (to what I actually use) sufficient enough to show my problem</em></p>
  
  <pre><code>Cells(1, 1).Value = "5/1/2014 6:30"
  soiDate = "$A$1"
  Cells(10, 6).Value = "6/5/2014 14:12"
  Cells(10, 10).Formula = "=(R[0]C[-4]-" &amp; soiDate &amp; ")*24" 'Error Occurs Here 
  </code></pre>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>The following does not work either:</p>
  
  <pre><code>Cells(10, 10).FormulaR1C1 = "=(R[0]C[-4]-" &amp; soiDate &amp; ")*24"
  </code></pre>