title: Insert formula into cell with VBA: Object-defined error
body: <p>I'm trying to use this in my VBA code:</p>
  
  <pre><code>  ActiveSheet.Range("A1:A1:).Formula = "='Sheet1'!A1" &amp; Chr(34) &amp; Chr(47) &amp; Chr(34) &amp; "'Sheet1'!A2"
  </code></pre>
  
  <p>This gives me Error: 1004, Object-defined error.</p>
  
  <p>I'd like to see in the cell formula that:</p>
  
  <blockquote>
    <p>='Sheet1'!A1"/"'Sheet1'!A2</p>
  </blockquote>
  
  <p>And if the value of the A1 cell is 10 and the A2 value is 20, the cell value should look like that:  <strong>10/20</strong></p>
  
  <p>What can be the problem?</p>