Sub ImpressionAvecFond()
Range("A1").CurrentRegion.Select
Selection.CopyPicture ' Copie la zone
ActiveSheet.Paste Destination:=ActiveSheet.Range("A1") 'crée un shape
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveWindow.SelectedSheets.PrintPreview
ActiveSheet.Shapes(ActiveSheet.Shapes.Count).Delete
End Sub