|
- Sub tt()
- arr = Sheet1.Range("a2:d" & Sheet1.[b65536].End(3).Row)
- ReDim brr(1 To 10 * UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- k = k + 1 '显示数组中的位置
- kk = kk + 1 '辅助中的记数
- If i > 1 And arr(i, 1) = 1 Then
- zjh = (kk \ 10 + 1) * 10 - kk '增加行
- k = k + zjh + 1
- kk = 1
- End If
- For j = 1 To UBound(arr, 2)
- brr(k, j) = arr(i, j)
- Next
- Next
- Sheet2.[g1].Resize(1, 4) = Array("辅助", "材料名称", "产地", "制造商")
- Sheet2.[g2].Resize(k, UBound(arr, 2)) = brr
- End Sub
复制代码 |
|