dim nextrow&
With Worksheets("Connexion ")
nextrow= .Cells(.Rows.Count, "B").End(xlUp).offset(1).row
Worksheets("Saisie").Range("F" & ActiveCell.Row).Copy .Cells(nextrow, "B")
Worksheets("Saisie").Range("C" & ActiveCell.Row).Copy .Cells(nextrow, "C")
Worksheets("Saisie").Range("D" & ActiveCell.Row).Copy .Cells(nextrow, "D")
Worksheets("Saisie").Range("P" & ActiveCell.Row).Copy .Cells(nextrow, "F")
Worksheets("Saisie").Range("Q" & ActiveCell.Row).Copy .Cells(nextrow, "G")
Worksheets("Saisie").Range("R" & ActiveCell.Row).Copy .Cells(nextrow, "H"))
Worksheets("Saisie").Range("M" & ActiveCell.Row).Copy .Cells(nextrow, "I")
Worksheets("Saisie").Range("N" & ActiveCell.Row).Copy .Cells(nextrow, "J")
End With