I am getting Runtime Error 1004 with this formula: ActiveCell.FormulaR1C1 = "=IF(RC[-7]="",IF(R6... ... Update : Here is the code on multiple lines: ActiveCell.FormulaR1C1 = ...show more
answers.yahoo.com