Building code.. Count... formula

[buzz71023]

I am struggling getting a code built that will count all the data point from L3 down then paste formula =ABS(L4-L3) from cell V4 down to the same row as the last data point in L. (If V4 = ABS(L4-L3) then V5 = ABS(L5-L4) and so on till the last data point row)

If it helps, I already have the data points counted as they are entered. E20 has the total number entered for that column.

Everything I have tried has failed badly. Any suggestions/help is much appreciated.

 

[buzz71023]

This was my latest attempt....

Sub Complete_Click()
Dim LROW As Single, DATAPTS As Integer

Range("M10").Select

DATAPTS = Range("E20")

    LROW = Selection.End(xlDown).Row

LASTROW = LROW

FILLPTS = DATAPTS + 2

FILLER = FILLPTS

[V4] = "=ABS(M11-M10)"

Range("V4").Copy

Range("V5:V" + FILLER).PasteSpecial

End Sub

 

[Michael M]

Maybe

Sub MM1()
Range("V4:V" & Cells(Rows.Count, "L").End(xlUp).Row).Formula = "=ABS(L4-L3)"
End Sub

 

[Teeroy]

I'm not sure that I completely understand your requirement but the following, even if it doesn't solve the problem, should point you on the right path.

Sub Complete_Click()
Dim LROW As Single
LROW = Range("M10").End(xlDown).Row
Range("V4").Formula = "=ABS(M11-M10)"
Range("V4").Resize(LROW - 10, 1).FillDown
End Sub

 

[buzz71023]

Thanks,
i had a mistype in my most recent post but I adjusted and both seem to work well.
Thanks you both again for the replies