|
本帖最后由 xdragon 于 2014-3-11 23:23 编辑
函数玩不来,我玩vba的。。。- Sub t()
- Dim arr(1 To 750, 1 To 6)
- Dim i As Integer, j As Byte, cnt As Byte, cnt2 As Byte
- For j = 1 To UBound(arr, 2)
- For i = 1 To UBound(arr)
- Do Until (i - 1) Mod 3 ^ (7 - j) = 3 ^ (7 - j) - 1 Or i > UBound(arr)
- arr(i, j) = cnt + j
- i = i + 1
- Loop
- If i <= UBound(arr) Then arr(i, j) = cnt + j
- cnt2 = cnt2 + 1
- cnt = cnt + 1
- If cnt2 = 3 Then cnt2 = 0: cnt = cnt - 2
- Next
- cnt = 0: cnt2 = 0
- Next
- Range("B1").Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |
评分
-
查看全部评分
|