Dim a, ar, r, num(1 To 3)
Sub demo()
[h:h].ClearContents
r = 0
a = [a1].CurrentRegion
For ar = 1 To UBound(a)
com 1, 1
Next
End Sub
Sub p(n)
If n > 3 Then
r = r + 1
Cells(r, "h") = Join(num, "")
Exit Sub
End If
For i = n To 3
If i > n Then
If num(i) = num(i - 1) Then GoTo 1
End If
v = num(n): num(n) = num(i): num(i) = v
p n + 1
v = num(n): num(n) = num(i): num(i) = v
1:
Next
End Sub
Sub com(k, n)
If n > 3 Then p 1: Exit Sub
For i = k To 3 + n
If i > k Then
If a(ar, i) = a(ar, i - 1) Then GoTo 1
End If
num(n) = a(ar, i)
com i + 1, n + 1
1:
Next
End Sub
祝順心,南無阿彌陀佛!