Question : VBA - Print All Worksheets
Answered by : michael-futral
'Print all worksheets
Worksheets.PrintOut
Source : https://www.excelhowto.com/macros/print-worksheets-vba/ | Last Update : Fri, 29 Apr 22
Question : VBA - Print Worksheets on One Page
Answered by : michael-futral
'Print Sheet1 exactly one page wide and tall
With Worksheets("Sheet1").PageSetup .Zoom = False .FitToPagesTall = 1 .FitToPagesWide = 1
End With
Source : https://www.excelhowto.com/macros/print-worksheets-vba/ | Last Update : Fri, 29 Apr 22