Autofill Two Columns Over Twenty Four Columns

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.

Please Login or Register  to view this content.

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

change

Range("I5:J5" & LastRow11).Select

to

Range("I5:J" & LastRow11).Select

That worked...I can't believe I didn't catch that!

Thanks!