|
Sub dd()
Dim arr(1 To 1000, 1 To 1), arr1()
Dim x, y, z, k, num, j
num = Len([a1])
ReDim arr1(1 To Len([a1]))
For j = 1 To Len([a1])
arr1(j) = Mid([a1], j, 1)
Next j
For x = 1 To num
For y = 1 To num
For z = 1 To num
If x <> y And x <> z And y <> z Then
k = k + 1
arr(k, 1) = arr1(x) & arr1(y) & arr1(z)
End If
Next z, y, x
Range("b1").Resize(k) = arr
End Sub |
评分
-
查看全部评分
|