Sub Copier()
With Application
If .WorksheetFunction.CountIf(Blad2.Range("G:G"), Blad1.Range("B7")) Then
MsgBox "La carte est déjà entrée"
Else
.ScreenUpdating = 0
Blad1.Range("B1:B10").Copy
Blad2.Range("A65536").End(xlUp).Offset(1).PasteSpecial Transpose:=True
.CutCopyMode = 0
End If
End With
End Sub