Hello!

Okay, so I have a document that I need to create. The rows are variable so I need to use the LastRow code. Below is what I have so far but it throws an error. Is there a way to copy Columns I and J to autofill to Column AF.

Dim LastRow11 As Long
LastRow11 = Range("G" & Rows.Count).End(xlUp).Row
Range("I5:J5" & LastRow11).Select
Selection.AutoFill Destination:=Range("I5:AF" & LastRow11), Type:=xlFillDefault
Image 1 is the original rows and Image 2 is what it should look like once it is done.

LastRow Autofill 1.JPG

LastRow Autofill 2.JPG