只有一个错误,就是第一个
这里
改成这样就好了
- For i = 1 To UBound(Arr, 2)
复制代码
代码整体为 我附件传不了,你自己试试看
- Sub 第二种()
- Dim Arr, X, A%(1 To 33), N%, B(1 To 33), i%, j&, k% '这个有点错误如何改
- Set Rng = [J10:L10]
- [J12:AP12] = ""
- Arr = [J10:L10]
- For i = 1 To UBound(Arr, 2)
- If Arr(1, i) > 0 Then A(Arr(1, i)) = 1: N = N + 1
- Next
- Arr = Range([C11], [C65536].End(3)(1, 6))
- For j = 1 To UBound(Arr) - 1
- X = 0: For k = 1 To 6: X = X + A(Arr(j, k)): Next
- If X = N Then For i = 1 To 6: B(Arr(j + 1, i)) = B(Arr(j + 1, i)) + 1: Next
- Next j
- [J12].Resize(1, 33) = B
- End Sub
复制代码 |