|
这也是可以的。- Sub 批量打印()
-
- Dim i&, j As Boolean
- Dim errmsg$
- Dim iStart&, iEnd&
- iStart = Application.InputBox("请输入要打印的起始页码:", "打印信息", , , , , , 1)
- iEnd = Application.InputBox("请输入要打印的结束页码:", "打印信息", , , , , , 1)
- If iStart <= 0 Or iEnd <= 0 Or iStart >= iEnd Then MsgBox "输入的页码无效": Exit Sub
- If MsgBox("要打印的页码范围 从 " & iStart & "到 " & iEnd & "页" & vbCr & _
- "确认打印?", vbOKCancel + vbInformation) = vbCancel Then
- Exit Sub
- End If
- On Error Resume Next
- For i = iStart To iEnd
- Range("j2") = i
- j = False
- j = ActiveSheet.PrintOut
- If Not j Then errmsg = errmsg & "第 " & i & " 页打印失败" & vbCr
- Next
- MsgBox "打印完成" & vbCr & errmsg
- End Sub
复制代码 |
评分
-
查看全部评分
|