|
发表于 2014-11-13 19:46
|
显示全部楼层
本楼为最佳答案
本帖最后由 易安1 于 2014-11-13 19:48 编辑
- Sub test()
- Dim brr(1 To 100000, 1 To 2), arr, ar
- Dim i As Integer, n As Integer
- ar = Array("仓库号", "物料号", "MAX", "MIN")
- With Sheet1
- arr = .Range("a3:d" & .Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(arr)
- m = i - 1
- For k = 1 To UBound(arr, 2)
- brr(5 * m + k, 1) = ar(k - 1)
- brr(5 * m + 5, 1) = ""
- brr(5 * m + k, 2) = arr(i, k)
- brr(5 * m + 5, 2) = ""
- Next
- Next
- End With
- With Sheet2
- .[a1].Resize(5 * m, 2) = brr
- .Columns("a:b").ColumnWidth = 27
- .Columns("a:b").HorizontalAlignment = xlCenter
- .Range("A1:A" & (5 * m)).SpecialCells(xlCellTypeBlanks).RowHeight = 8
- For n = 1 To 5 * m Step 5
- With .Range(.Cells(n, 1), .Cells(n + 3, 2))
- .Borders.LineStyle = xlContinuous
- .RowHeight = 19
- End With
- Next
- End With
- End Sub
复制代码 |
|