|
一个较复杂的数据分组,不知道如何写程序,求高手出招,谢谢!
改动数字后再按一下按钮吧,change事件虽然可以解决,但是没看到你的最终表,
担心你套用时会出现问题。
- Private Sub CommandButton1_Click()
- Dim arr, i&, j&, brr, n&, m&
- n = [e1]: m = 1
- arr = [a3].CurrentRegion
- brr = [d3].Resize(UBound(arr) * 3 - 1, n)
- [d4].Resize(65533, 253).ClearContents
- For j = 1 To UBound(brr, 2)
- For i = 1 To brr(1, j)
- m = m + 1
- brr(i * 3 - 1, j) = arr(m, 1)
- brr(i * 3, j) = arr(m, 2)
- Next i
- Next j
- [d3].Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码
|
|