Sub Macro2()
ChemFich = Application.GetSaveAsFilename(FileFilter:=" PDF Files (*.pdf), *.pdf")
if ChemFich="" then exit sub
ActiveSheet.PageSetup.PrintArea = "$B$1:$O$110"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ChemFich & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False 'affiche le fichier PDF
End Sub