Forum Discussion
VBA not translating FormulaR1C1 index
So everytime i try to use a VBA code like this to insert an index function: Range("K2").Select
ActiveCell.FormulaR1C1 = _
"=INDEX(RC[-1],MATCH(RC[-1],RC[-1],0))" in K2 it gives bac...
LucasHernandez Does it work if you use code like this:
ActiveCell.Formula = "=Index(J2,MATCH(J2,J2,0))"