I have searched with no luck as to how I may copy the cells A1-C1 and then autofill this data into A2:C using VBA.
The number of rows to Autofill will vary depending on the data I paste.
I have tried the below code with no luck. I'm obviously missing something.
Range("A1:C1").AutoFill Destination:=Range("A2:C" & Lastrow)
Could someone kindly show me the code I need please?
Sample01.xlsx