Sub printRegister()
Dim arrData(), arrReg(), i&
arrData = Sheets("报名登记表信息").Range("a1").CurrentRegion.Value
arrReg = [A1:P33].Value
For i = 2 To UBound(arrData)
'arrReg(5, 3) = arrData(i, 1) '总序号 = ?
'arrReg(5, 3) = arrData(i, 2) '序号 = ?
arrReg(3, 4) = arrData(i, 3) '毕业学校d3
arrReg(3, 13) = arrData(i, 4) '学籍号m3
arrReg(5, 3) = arrData(i, 5) '姓名c5
arrReg(5, 7) = arrData(i, 6) '性别g5
arrReg(5, 12) = arrData(i, 7) '出生年月L5
arrReg(6, 3) = arrData(i, 8) '籍贯c6
arrReg(6, 7) = arrData(i, 9) '民族g6
arrReg(6, 12) = arrData(i, 10) '准考证号码l6
[a1].Resize(UBound(arrReg), UBound(arrReg, 2)) = arrReg
Me.PrintOut
Next i
End Sub
信息表准考证7.rar
(44.1 KB, 下载次数: 159)
|