|
Sub twosides_Printing()
Dim Pages As Integer, even As Integer, odd As Integer
If VBA.IsEmpty(ActiveSheet.UsedRange) Then MsgBox "当前工作表为空!", 64, "出错": Exit Sub
ActiveWindow.View = xlPageBreakPreview
Pages = Application.ExecuteExcel4Macro("get.document(50)")
For odd = 1 To Int(Pages / 2)
ActiveSheet.PrintOut form:=2 * odd - 1, To:=2 * odd - 1, copies:=1, collate:=True
Next
MsgBox "请将打印纸反向装入打印机中," & Chr(10) & "开始打印另一面!", 64, "友情提示"
For even = 1 To Int(Pages / 2)
ActiveSheet.PrintOut from:=2 * even, To:=2 * even, copies:=1, collate:=True
Next
ActiveWindow.View = xlNormalView
End Sub |
|