|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Option Explicit
- Dim sRow As Integer, eRow As Integer, i%
- Sub 自定义打印()
- sRow = Sheet1.Range("R1").Value
- eRow = Sheet1.Range("S1").Value
- If sRow > eRow Then MsgBox "起始行号不正确!", , "提示": Exit Sub
- ActiveSheetPrintOut
- End Sub
- Sub 单张打印()
- Sheet1.Range("B2:O13").PrintOut
- End Sub
- Sub 全部打印()
- sRow = 3
- eRow = Sheet2.Range("B65536").End(3).Row
- ActiveSheetPrintOut
- End Sub
- Private Sub ActiveSheetPrintOut()
- If MsgBox("下面将打印从第 " & sRow - 2 & " 位第 " & eRow - 2 & " 位同学的《报告书》。" & vbCrLf _
- & "打印中不可停止!!!" & vbCrLf & vbCrLf & "是否打印?", vbQuestion + vbYesNo, "打印") = vbYes Then
- With Sheet1
- For i = sRow To eRow
- .Range("Q1") = i
- .Range("B2:O13").PrintOut
- Next
- End With
- End If
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|