Offset previous row

[Av8tordude]

How can include offset the previous row in the Red Color code?

For i = 3 To LRow
    Range("I" & i) = [COLOR=#ff0000]WorksheetFunction.Average("I" & i, "L" & i)[/COLOR]
Next i

 

[mohadin]

HI

Range("I" & i) = WorksheetFunction.Average(Range("I" & i - 1), Range("L" & i - 1))
or
  Range("I" & i) = WorksheetFunction.Average(Range("I" & i).Offset(-1, 0), Range("L" & i).Offset(-1, 0))

 

[Av8tordude]

Thank you mohadin....Works great!

 

[mohadin]

You are well come
And thank you