Range Sum()
 

Hello, i was wondering if anyone can help with this issue, this is my formula:

Cells(((Lo) - 1), 8) = WorksheetFunction.Sum(Cells((L), 8), Cells((Lo), 8))

The problem is that with this code it only adds the 2 cells instead of the
range, how can i acomplish this?