Sub Bouton16_EnregistrerNvDoc()
Application.ScreenUpdating = False
Dim DerligSrc&, DerligDst&, F
DerligSrc = Feuil1.Range("A" & Rows.Count).End(xlUp).Row
F = "Documents " & Feuil1.[C6]
If Feuil2.Name = F Then
DerligDst = Feuil2.Range("C" & Rows.Count).End(xlUp).Row + 1
Feuil1.Range("A11:J" & DerligSrc).Copy
Feuil2.Range("C" & DerligDst & ":L" & DerligDst).PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Else
DerligDst = Feuil3.Range("C" & Rows.Count).End(xlUp).Row + 1
Feuil1.Range("A11:J" & DerligSrc).Copy
Feuil3.Range("C" & DerligDst & ":L" & DerligDst).PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End If
End Sub