|
在sheet1表格中输入下面代码即可。
Private Sub CommandButton1_Click()
Sheets("个人表1").Activate
ActiveSheet.PageSetup.PrintArea = "$A$1:$L$26"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
Range("A3").Select
End Sub
Private Sub CommandButton2_Click()
Sheets("个人表1").Activate
ActiveSheet.PageSetup.PrintArea = "$A$1:$L$26"
xx = InputBox("输入打印范围,用-号隔开", "按需打印", "1-10")
Application.ScreenUpdating = False
Application.DisplayAlerts = False
n = Split(xx, "-")(0): m = Split(xx, "-")(1)
arr = Sheets("总表").Range("b7:b" & Sheets("总表").Cells(7, 2).End(4).Row)
For i = n To m
If Len(arr(i, 1)) Then
ActiveSheet.Range("b3") = arr(i, 1)
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
End If
Next i
Range("A3").Select
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub |
|