Dim DerLigne, DerColonne As Integer
DerLigne = Range("O" & Rows.Count).End(xlUp).Row
DerColonne = Cells(DerLigne, Columns.Count).End(xlToLeft).Column
Range("P2").Select
Selection.Copy
Selection.AutoFill Destination:=Range(Cells(2, 16), Cells(DerLigne, 16)), Type:=xlFillDefault
Range(Cells(2, 16), Cells(DerLigne, 16)).Select
Selection.Copy
Selection.AutoFill Destination:=Range(Cells(2, 16), Cells(DerLigne, DerColonne)), Type:=xlFillDefault
Range("P2").Select