Essaie :
Sub ImprimerVpat()
Dim x&, HPB, ligne&, i&, Lig As Long, Chemin As String
x = 1
With Sheets("Rapport")
Lig = Range("F:F").Find("*", , xlValues, , xlByRows, xlPrevious).Row
If Lig < 88 Then Lig = 88
.PageSetup.PrintArea = "A1:L" & Lig
For i = 1 To .HPageBreaks.Count
ligne = .HPageBreaks(i).Location.Row
If .Cells(ligne, "F").Text <> "" Then x = x + 1
Next
Chemin = Left(Range("source"), InStrRev(Range("source"), "\"))
.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
Chemin & Range("MB") & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False
End With
End Sub
Daniel