Sub Impr2()
If Sheets.Count > 3 Then
Dim WB1 As Workbook
Dim MyArray() As String
Dim i As Integer, X As Byte
Set WB1 = ThisWorkbook
For i = 4 To Sheets.Count
ReDim Preserve MyArray(X)
MyArray(X) = Sheets(i).Name
X = X + 1
Next
WB1.Worksheets(MyArray).Select
ActiveWindow.SelectedSheets.PrintOut Collate:=True, Preview:=True
Else
MsgBox "Il n'y a aucune feuille à imprimer, veuillez en générer avant de lancer l'impression !"
End If
End Sub