Sub ajoutfeuillenommée()
Sheets.Add after:=Sheets("Matrice")
ActiveSheet.Name = "S" & SMax
ActiveSheet.Name = "Sem N°" & UserForm1.TextBox1.Value
With UserForm1
Sheets("Matrice").Range("D7") = .ComboBox1.Value
End With
Sheets("Matrice").Range("B2:K40").Copy
[COLOR="#FF0000"]ActiveSheet.Paste Destination:=ActiveSheet.Name.Range("B2:K40")[/COLOR]
End Sub