Sub Export_PDF()
Dim PDF_Path$, Nom_PDF$
PDF_Path = ThisWorkbook.Path & "\"
Nom_PDF = InputBox("Nom du PDF?", "Export PDF", "test.pdf")
Application.ScreenUpdating = False
ActiveSheet.PageSetup.PrintArea = "$C$6:$AH$33"
With ActiveSheet.PageSetup
.LeftMargin = Application.InchesToPoints(0)
.RightMargin = Application.InchesToPoints(0)
.TopMargin = Application.InchesToPoints(0)
.BottomMargin = Application.InchesToPoints(0)
.HeaderMargin = Application.InchesToPoints(0)
.FooterMargin = Application.InchesToPoints(0)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 600
.CenterHorizontally = True
.CenterVertically = True
.Orientation = xlLandscape
.Draft = False
.PaperSize = xlPaperA3
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
Range("$C$6:$AH$33").ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=PDF_Path & Nom_PDF, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=False, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
End Sub