Hi everyone,
Please I would need your help
My case : I have the column A to S filled, the number of lines is variable monthly but this is the same information (duplicate) and i put news lines into the column A to S (end of variable lines), and I would like also duplicate the new lines until empty cell from my column W (who is eveytime filled with other info). The issue with my code it's working until COPY. the end of the code for autofill destination who is variable is not working
Please see my code :
Range("A1048576").End(xlUp).Offset(0, 0).Select
Range(ActiveCell, ActiveCell.Offset(0, 19)).Copy
DernLigne = Range("W" & Rows.Count).End(xlUp).Row
Range("A1048576").End(xlUp).Offset(1, 0).AutoFill Destination:=Range("A2:A" & DernLigne)
what the issue is and the solution according to you ?
Thanks for your help
Please I would need your help
My case : I have the column A to S filled, the number of lines is variable monthly but this is the same information (duplicate) and i put news lines into the column A to S (end of variable lines), and I would like also duplicate the new lines until empty cell from my column W (who is eveytime filled with other info). The issue with my code it's working until COPY. the end of the code for autofill destination who is variable is not working
Please see my code :
Range("A1048576").End(xlUp).Offset(0, 0).Select
Range(ActiveCell, ActiveCell.Offset(0, 19)).Copy
DernLigne = Range("W" & Rows.Count).End(xlUp).Row
Range("A1048576").End(xlUp).Offset(1, 0).AutoFill Destination:=Range("A2:A" & DernLigne)
what the issue is and the solution according to you ?
Thanks for your help