|
楼主 |
发表于 2017-2-9 20:37
|
显示全部楼层
Sub test()
Dim Arr, Brr%(), r&, c%, x%
[k11].CurrentRegion.Offset(1).ClearContents
Arr = Range("c11:h" & Cells(Rows.Count, 3).End(xlUp).Row)
ReDim Brr%(1 To UBound(Arr), 1 To 33)
For c = 1 To 33
Brr(1, c) = 1
Next
For c = 1 To 6
x = Arr(1, c) '依次读取c11:h11的6个号数
Brr(1, x) = 0 '把出现过号的位置的1改成0
Next
For r = 2 To UBound(Arr)
x = 1 '初始值,从第一个号始
For c = 1 To 33
If Arr(r, x) = c Then
Brr(r, c) = 0
If x < 6 Then x = x + 1
Else
Brr(r, c) = Brr(r - 1, c) + 1
End If
Next
Next
[k11].Resize(UBound(Brr), 33) = Brr
End Sub
|
|