Excel 如何利用vba批量设置打印格式

2024-12-27 11:18:24
推荐回答(1个)
回答1:

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