|
- Sub 按钮1_Click()
- Dim arr, k0, brr(), k, crr()
- k0 = [a1].End(4).Row - 1
- arr = [a2].Resize(k0, 2)
- ReDim brr(1 To k0)
- k = 1: brr(k) = 1
- For i = 2 To k0
- If arr(i, 1) <= arr(i - 1, 1) Then k = k + 1: brr(k) = i
- Next
- k = k + 1: brr(k) = i
- ReDim Preserve brr(1 To k)
- ''''''''
- ReDim crr(1 To k * 5, 1 To 2)
- For i = 1 To k - 1
- For j = 1 To 4
- crr((i - 1) * 5 + j, 1) = j
- Next
-
- For j = brr(i) To brr(i + 1) - 1
- crr((i - 1) * 5 + arr(j, 1), 2) = arr(j, 2)
- Next
- Next i
- [d2].Resize(9999, 2).ClearContents
- [d2].Resize(k * 5, 2) = crr
- End Sub
复制代码
。。。
数组解法
|
|