这段宏可以简化
Sub 打印(S As Integer, T As Integer)
With Columns("B:P")
.Borders.LineStyle = xlNone
.ClearContents
End With
Range("T2:V4").Copy
W = 2
L = S * 3 - 2
For I = S To T
K = K + 1
If I = 6 Then W = 6: L = -1: K = 1
If I = 11 Then W = 10: L = -1: K = 1
Cells(W, L + K * 3).PasteSpecial Paste:=xlPasteAll
Next
ActiveSheet.PrintPreview '浏览
'ActiveSheet.PrintOut '打印
End Sub
zjdh 发表于 2012-9-15 21:40
这段宏可以简化
Sub 打印(S As Integer, T As Integer)
With Columns("B:P")
兄弟
我想扩充到20个标签,弄了好些时间了没扩成
想问一下这个
For I = S To T
K = K + 1
If I = 6 Then W = 6: L = -1: K = 1
If I = 11 Then W = 10: L = -1: K = 1
Cells(W, L + K * 3).PasteSpecial Paste:=xlPasteAll
该怎改?
Print_Area的名称定义区域我改成了=打印标签!$A$1:$P$17了
弹窗上的位置按钮了扩到20了,
Private Sub CommandButton1_Click()
里面的位置值我也扩到了20
还是弄不了