![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77094b36acaf2edd6f5ed6148c1001e9380193a4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
Sub a()
Dim str1$, str2$, str3$, i%, j%
For i = 1 To 3
str1 = ""
str2 = ""
str3 = ""
str1 = Cells(Int(Rnd() * 5 + 1), i)
str2 = Cells(Int(Rnd() * 5 + 1), i)
str3 = Cells(Int(Rnd() * 5 + 1), i)
Do Until str2 <> str1
str2 = Cells(Int(Rnd() * 5 + 1), i)
Loop
Do Until str3 <> str2 And str3 <> str1
str3 = Cells(Int(Rnd() * 5 + 1), i)
Loop
Cells(1, i + 3) = str1 & "和" & str2 & "和" & str3
Next i
End Sub
追问能把所有结果全部显示出来吗?不仅仅是随机数....
追答Sub b()
Dim i%, j%, k%, a%, b%, c%
For i = 1 To 3
k = 1
For a = 1 To 3
For b = a + 1 To 4
For c = b + 1 To 5
Cells(k, i + 3) = Cells(a, i) & "和" & Cells(b, i) & "和" & Cells(c, i)
k = k + 1
Next c
Next b
Next a
Next i
End Sub
这样吗?
追问辛苦啦,但是这个缺了好多啊~~应该一共有1000种....可以全部列出来嘛?实在不好意思啊~
追答Sub b()
Dim i%, j%, k%, a%, b%, c%
For i = 1 To 3
k = 1
For a = 1 To 3
For b = a + 1 To 4
For c = b + 1 To 5
Cells(k, i + 6) = Cells(a, i) & "和" & Cells(b, i) & "和" & Cells(c, i)
k = k + 1
Next c
Next b
Next a
Next i
k = 1
For a = 1 To 10
Cells(k, 4) = Cells(a, 7)
For b = 1 To 10
Cells(k, 5) = Cells(b, 8)
For c = 1 To 10
Cells(k, 6) = Cells(c, 9)
k = k + 1
Next c
Next b
Next a
For a = 4 To 5
For b = 1 To [f65536].End(xlUp).Row
If Cells(b, a) = "" Then
Cells(b, a) = Cells(b - 1, a)
End If
Next b
Next a
Range("g1:i10").Clear
End Sub本回答被提问者采纳