本帖最后由 爱疯 于 2013-11-13 16:17 编辑
Sub test()
Dim A, B(1 To 30, 1 To 9), n, i, x, y, c, z, r, p
A = Sheets(1).Range("A1").CurrentRegion
n = UBound(B)
Sheets(2).Select
For i = 2 To UBound(A)
'参考值
x = i - 1 '序号
y = x \ n '商
z = x Mod n '余数
r = IIf(z = 0, n, z) '行
If z = 0 Then '列
c = IIf(y Mod 2 = 0, 5, 0)
Else
c = IIf(y Mod 2 = 0, 0, 5)
End If
'装入
B(r, c + 1) = x
B(r, c + 2) = A(i, 1)
B(r, c + 3) = A(i, 2)
B(r, c + 4) = A(i, 3)
'打印
If x Mod (n * 2) = 0 Or i = UBound(A) Then
Range("a3:i65536").ClearContents
Range("a3").Resize(UBound(B), UBound(B, 2)) = B
p = x \ (n * 2)
p = IIf(x Mod (n * 2) = 0, p, p + 1) '页号
Range("d34") = "第 " & p & " 页"
ActiveSheet.PrintOut
Erase B
End If
Next i
End Sub
批量打印2.rar
(17.17 KB, 下载次数: 37)