Option Explicit
Sub Imprimer()
Dim nb
[e8].AutoFilter
Columns("a:c").EntireColumn.Hidden = True
ActiveSheet.[d8:f10000].AutoFilter Field:=2, Criteria1:=[b4].Value
nb = Application.Subtotal(3, [e9:e1000])
ActiveSheet.PrintOut Copies:=nb, Collate:=True
[e8].AutoFilter
Columns("a:c").EntireColumn.Hidden = False
End Sub