title: Switch off R1C1 reference style for recorded VBA macros
body: <p>In recorded VBA macros, it seems that their formulas use <code>R1C1 reference style</code>. For instance, to fill in <code>B4</code> with <code>B2+1</code>:</p>
  
  <pre><code>Range("B4").Select
  ActiveCell.FormulaR1C1 = "=R[-2]C+1"
  </code></pre>
  
  <p>Does anyone know if it is possible to switch off this mode? For instance, let recorded macro look like:</p>
  
  <pre><code>Range("B4").Select
  ActiveCell.Formula = "=B2+1"
  </code></pre>