代码如下:
Sub 排列()
For i1 = 1 To 5
For i2 = 1 To 5
If i1 <> i2 Then
For i3 = 1 To 5
If i1 <> i3 And i2 <> i3 Then
For i4 = 1 To 5
If i1 <> i4 And i2 <> i4 And i3 <> i4 Then
For i5 = 1 To 5
If i1 <> i5 And i2 <> i5 And i3 <> i5 And i4 <> i5 Then
n = n + 1
Range("A" & n) = i1 & i2 & i3 & i4 & i5
End If
Next
End If
Next
End If
Next
End If
Next
Next
End Sub
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b8014a90f603738d18a671c6be1bb051f919ec62?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)