ActiveCell.FormulaR1C1 = "=IF(Results!R[-1]C[1] <
"""",Results!R[-1]C[1],"""")"

this does result in correct formula.



"RobcPettit" wrote in message
...
hi, im using ActiveCell.FormulaR1C1 = "=IF(Results!R[-1]C[1]
<"""",Results!R[-1]C[1],"""")" which should give me =IF(Results!
A3<"",Results!A3,"") but instead gives me =IF
(Results!'A3'<"",Results!'A3',""). Any ideas how to get rid of those
' .
Regards Robert