|
楼主 |
发表于 2014-11-27 11:05
|
显示全部楼层
- Sub Macro1()
- Range("T:T").ClearContents
- Dim arr, brr(1 To 60000, 1 To 1)
- arr = [r3:r5]
- n = UBound(arr)
- For i = 1 To n - 2
- For i2 = 1 To Len(arr(i, 1))
- s1 = Mid(arr(i, 1), i2, 1)
- For j = i + 1 To n - 1
- For j2 = 1 To Len(arr(j, 1))
- s2 = Mid(arr(j, 1), j2, 1)
- For k = j + 1 To n
- For k2 = 1 To Len(arr(k, 1))
- s3 = Mid(arr(k, 1), k2, 1)
- s = s + 1
- brr(s, 1) = "'" & s1 & s2 & s3
- Next
- Next
- Next
- Next
- Next
- Next
- Range("T1").Resize(s) = brr
- End Sub
复制代码 |
|