Bonjour,
Si tu laisse ce code, ce sera la cellule active du W1.
Sub Selection_Plage()
Set W1 = Workbooks("Extraction.xlsx")
Set W2 = Workbooks("BD.xlsx")
DerLig = W1.ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
W1.ActiveSheet.Range("A2:P" & DerLig).Copy
W2.ActiveSheet.Paste
End Sub
Sinon "coller sous les données deja presente" du W1
Sub Selection_Plage()
Set W1 = Workbooks("Extraction.xlsx")
Set W2 = Workbooks("BD.xlsx")
DerLig = W1.ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
DerLig2 = W2.ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
W1.ActiveSheet.Range("A2:P" & DerLig).Copy
W2.ActiveSheet.Range("A" & DerLig2 + 1).Select
W2.ActiveSheet.Paste
End Sub
A+