Can anyone tell me the definitive difference between the range properties
FormulaR1C1 and Formula? I know the former is meant to use R1C1 notation the
latter seems to work just as well for relative formulas, e.g. if the cursor
is in A2:
ActiveCell.FormulaR1C1 = "=R[-1]C" gives me the formula =A1 in the same way
as:
ActiveCell.Formula = "=R[-1]C" does.

However, while:
ActiveCell.Formula = "=A1" gives me the same,
ActiveCell.FormulaR1C1 = "=A1" gives me ='A1'