Integrate VBA to QM2

[stersergiu]

Hello ,
I have another macro that I can't figure out how to integrate it into QM2.

Code:

Copy      Help

Sub AutoFill()

     Dim LastRow As Long
     LastRow = Columns(1).Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
     ActiveCell.AutoFill Destination:=Range(ActiveCell, Cells(LastRow, ActiveCell.Column))

End Sub

When I tried to add property to Columns(1) function it tells me "Expected 0 arguments, not 1.";