Sub Impression()
With ActiveSheet 'à adapter
.PageSetup.Zoom = False
.PageSetup.FitToPagesWide = 1 '1 page en largeur
.PageSetup.PrintArea = "B:N" 'zone d'impression
.[O2] = "=COUNTIF(B2:N2,""><"")+COUNT(B2:N2)" 'critère de filtrage
.[A:N].AdvancedFilter xlFilterInPlace, .[O1:O2] 'filtre avancé
'.PrintPreview 'pour tester
.PrintOut 'pour imprimer
.[O2] = ""
If .FilterMode Then .ShowAllData
End With
End Sub