|
本帖最后由 zjdh 于 2011-8-16 10:14 编辑
你的不正确!
“工号”与“部门”的内容反啦!
你要第一行也利用起来容易:
Sub test()
t = Timer
arr = Sheet12.Range("A3:AE" & Sheet12.Range("A65536").End(3).Row)
ReDim BRR(1 To UBound(arr) * 3, 1 To 25)
For i = 1 To UBound(arr)
For j = 1 To 25
If j = 1 Then
BRR(i * 3 - 2, 1) = arr(i, 1)
BRR(i * 3 - 2, 2) = arr(i, 4)
BRR(i * 3 - 2, 3) = arr(i, 2)
BRR(i * 3 - 2, 4) = arr(i, 3)
j = j + 3
End If
If j > 4 And j < 9 Then BRR(i * 3 - 2, j) = arr(i, j)
If j > 8 And j < 18 Then BRR(i * 3 - 2, j) = arr(i, j + 5)
If j > 17 Then BRR(i * 3 - 2, j) = arr(i, j + 6)
Next
Next
With Sheet7
.Range("A2").Resize(.Range("A65536").End(3).Row, 25).ClearContents
.Range("A2").Resize(UBound(BRR), 25) = BRR
W = .Range("A65536").End(3).Row
arr = .Range("A1:Y1")
For i = W To 3 Step -3
.Cells(i - 1, 1).Resize(, 24) = arr
Next
.Range("J:J,K:K,W:W").WrapText = True
.Activate
End With
MsgBox "创建成功!!总计用时 " & Format(Timer - t, "0.00") & " 秒!!", 64, "提示"
End Sub
|
|