Can't seem to get For loop down (index match + last row)

[canyon]

Trying to run a forloop to iterate a formula over some cells as part of a larger bit of code. Everything runs smoothly up until this point where I get the error :

"Method 'Range' of object'_Global' failed

Dim LastRow As Long
LastRow = Cells(Rows.Count, "C").End(xlUp).Row

For i = 2 To LastRow

range("I" & i).Formula = _
    "=(INDEX(Master!$B:$B,MATCH(salesorders_1!D" & i & ",Master!$E:$E,0))"
Next i

 

[Fluff]

No need to do that in a loop, you can do it all at once like

Dim LastRow As Long
LastRow = Cells(Rows.count, "C").End(xlUp).Row


Range("I2:I" & LastRow).Formula = _
    "=INDEX(Master!$B:$B,MATCH(salesorders_1!D2,Master!$E:$E,0))"

 

[canyon]

No need to do that in a loop, you can do it all at once like

Dim LastRow As Long
LastRow = Cells(Rows.count, "C").End(xlUp).Row


Range("I2:I" & LastRow).Formula = _
    "=INDEX(Master!$B:$B,MATCH(salesorders_1!D2,Master!$E:$E,0))"

Far more simple. thank you!

 

[Fluff]

You're welcome & thanks for the feedback.