Formula R1C1 problem

Hi, all. I need to use a loop to run through the necessary column, and if match the condition, then autofill the column's data to desired column. but when the macro run to ActiveCell.FormulaR1C1 = "=RC[-123+i]" , it got error msg says : run time error"1004" Application-defined or object-defined error? how should i modify this problem?? Please help. Thank you!

Please Login or Register  to view this content.