With my last post, I was able to use the code in another part of my macro, but it needs to extend an extra 3 rows. I'm sure this has to do with offset, but have tried several different way and only get errors.
Here is the code and it autofills down to the last row, but how can it continue past for 3 more rows? There is another part of the macro that will add data to the sheet for an additional 3 rows and would like not having to copy and drag as it should be easier.
Dim LastRow As Long
LastRow = Range("I" & Rows.Count).End(xlUp).Row
Range("K5:L5").AutoFill Destination:=Range("K5:L" & LastRow)
Bookmarks