Sub Macro1()
With Sheets("Entrée")
.Cells(2, 9) = .Cells(2, 9) + 1
Application.ActivePrinter = "Brother HL-2240 series sur Ne05:"
ExecuteExcel4Macro _
"PRINT(1,,,2,,,,,,,,2,""Brother HL-2240 series sur Ne05:"",,TRUE,,FALSE)"
MsgBox "Nombre d'impression " & .Cells(2, 9).Value
End With
End Sub