VBA Auto Fill

[Toufic Leen]

Hi guys
I need to create a VBA for Autofill in Excel and I failed every time would you please help?
Basically I need to AutoFill F2:F in VBA
the worksheet is here:

https://app.box.com/s/bk40q6zro6km4y75guk1

 

[crouchsw]

Did you mean E2? You just have a 0 in it. It will autofill with the same number (0,0,0, etc.). If you meant to calculate, then you should have =C2-D2 in cell E2. With that in place, the following code will do the autofill:

Sub autofillblocks()
Dim lastrow As Integer
Dim range1 As String
    lastrow = Range("A:D").Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    range1 = "E2:E" & lastrow
    Range("E2").Select
    Selection.AutoFill Destination:=Range(range1)
    Range(range1).Select
End Sub

 

[Toufic Leen]

yes this is perfect, thanks bro