|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 liagmy06 于 2012-12-2 13:02 编辑
学习了,但是我还是菜鸟,难理解!顺便请斑竹帮我解释一下我下面的代码,谢谢!
For d = 1 To nn - 1 'nn为我输入的数字:2/4/8/16/32/64
Cells(d + 1, 5) = "第" & d & " 轮:"
For i = 1 To 64
b(i) = 0
Next i
m = 5
For i = 1 To nn
If b(i) = 0 Then
b(i) = 1
m = m + 1
For j = 1 To nn
If b(j) = 0 And a(i, j) = 0 Then
Cells(d + 1, m) = Cells(i + 1, 3) & " vs " & Cells(j + 1, 3) & ""
b(j) = 1: a(i, j) = 1: a(j, i) = 1
j = nn
End If
Next j
End If
Next i
Next d
|
|