Sub test()
Dim A, i
A = Sheet1.Range("a1").CurrentRegion
For i = 6 To UBound(A)
With Sheet2
.Range("b4") = A(i, 1)
.Range("a6") = A(i, 2)
.Range("c6") = A(i, 9)
.PrintOut
End With
Next i
End Sub 登记表2.rar(28.37 KB, 下载次数: 27)
Sub test()
Dim A, i
A = Sheet1.Range("a1").CurrentRegion
For i = 6 To UBound(A)
With Sheet2
.Range("b4") = A(i, 1)
.Range("a6") = A(i, 2)
.Range("c6") = A(i, 9)
.PrintOut
End With
Next i
End Sub 登记表2.rar(28.37 KB, 下载次数: 27)