Public Sub printArea() Application.PrintCommunication = False With ActiveSheet.PageSetup.printArea = "$A$1:$N$21".FitToPagesWide = 1 .FitToPagesTall = 0 End With Application.PrintCommunication = TrueEnd Sub