Hi,
I have a VB code which auto fills column A down to the last row with data in, i would like to expand this to auto fill columns A:C
![]()
Sub test() Dim lastrow As Long lastrow = Worksheets("sheet1").Range("D8").End(xlDown).Row With Worksheets("Sheet1").Range("A2") .AutoFill Destination:=Range("A2:A" & lastrow&) End With End Sub
Bookmarks