|
发表于 2013-2-12 18:06
|
显示全部楼层
本楼为最佳答案
- Sub t()
- Dim i&, j%, k%, ar, br()
- ar = Sheet1.Range("a1", Sheet1.[d65536].End(3))
- ReDim br(1 To 11, 1 To (UBound(ar) + 1) / 10)
- For i = 1 To (UBound(ar) + 1) Step 10
- k = k + 1
- br(1, k) = ar(i, 1)
- br(2, k) = ar(i, 2)
- For j = 3 To 11
- br(j, k) = ar(i + j - 3, 4)
- Next
- Next
- With Sheet2
- .Cells.ClearContents
- .[a1].Resize(11, k) = br
- With .Range("A1:D1").Font
- .Color = -16776961
- .Bold = True
- End With
- With .Range("A2:D2")
- .NumberFormatLocal = "yy-m-d"
- .Font.Bold = True
- End With
- With .Range("A3:D11")
- .HorizontalAlignment = xlCenter
- .Font.Bold = True
- End With
- End With
- End Sub
复制代码 |
|