Receiving runtime error 1004: Application defined or Object defined error

[rkb1510]

I am receiving Runtime Error 1004 for following line in VBA code containing formula. How can I resolve or what will be remedy for that.

ActiveCell.FormulaR1C1 = "=INDEX([Test_Table.csv]obj_1_Table!$F:$F,MATCH(RC[3],[Test_Table.csv]obj_1_Table!$A:$A,0))"

 

[MARK858]

You are mixing A1 and R1C1 references, manually type your formula in the cell, turn on the macro recorder, delete the last closing parentheses and then type the parentheses back in and then turn off the macro recorder.
It will give you the correct formula in R1C1 style.