Auto Insert Formula for Next New Item using AutoFill with Excel VBA

Auto Insert Formula for Next New Item using AutoFill with Excel VBA

[ML-qlgu]

This helped so much, thank you for making this video

[oussamaamor]

You are really professional. thank you very much

[karmusinghsiddhu]

'Private Sub Target As Range)
'On Error Resume Next
'Application.ScreenUpdating = True
'With Sheet1
'Rows(lastrow).AutoFill Rows(lastrow).Resize(2), xlFillDefault
Range("A1:A3").AutoFill Destination:=Range("A1:A60")

' Range("M10").Formula = "=IF(OR(ISBLANK(D6), ISBLANK(E6), ISBLANK(F6), ISBLANK(C6)), (FG65+D6-E6-F6))"
Range("A1:A3").AutoFill Destination:=Range Balance("A61")
("A1+A60)


'Application.ScreenUpdating = False

'End If
'End With
'End Sub
can pls help me correct