Sub ImpressionDynamiqueFormules2()
ActiveWindow.DisplayZeros = False
lignefin = [A:A].Find("", SearchOrder:=xlByRows, SearchDirection:=xlNext, LookAt:=xlWhole, LookIn:=xlValues).Row
ActiveSheet.PageSetup.PrintArea = Range("a1", Cells(lignefin - 1, 2)).Address
ActiveWindow.SelectedSheets.PrintPreview
End Sub