title: Mixing R1C1 and A1 notation
body: <p>Struggling through applying a normal excel formula into R1C1 format so I can loop the formula in VBA. The question is how can I refer to columns in other sheets using R1C1 notation. So in the following formula:</p>
  
  <pre><code>ell.Offset(0, 5).FormulaR1C1 = "=IF(LEN(R[]C[-2])&gt;0,(R[]C[-2])*VLOOKUP([R[]C[1]),Core!A:C,3,FALSE)/_
  VLOOKUP(R[]C[-1],Core!A:C,3,FALSE),R[]C[4])"
  </code></pre>
  
  <p>How do I get Core!A:C into R1C1 format? I know you can't mix the two formats but i'm afraid i don't know the syntax for this! Any help is appreciated!</p>
  
  <p><strong>EDIT:</strong> </p>
  
  <pre><code>Sub Expo_dos_Formulas()
  
  '===============================================================================
  Sheets("Data_Sheet").Activate
  
  For Each cell In Range("G5:G500")
      If cell &lt;&gt; "Error" Then
          cell.Offset(0, 5).FormulaR1C1 = "=IF(LEN(R[]C[-2])&gt;0,_
  (R[]C[-2])*VLOOKUP([R[]C[1]),Core!RC1:RC3,3,FALSE)/VLOOKUP(R[]C[-1],_
  Core!RC1:RC3,3,FALSE),R[]C[4])"
      End If
  Next
  '===============================================================================
  
  End Sub
  </code></pre>