- Sub aaa()
- Dim arr, i&, j&, a&, b&, c&, brr, n&
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 6)
- For i = 1 To UBound(arr)
- For a = 1 To 3
- For b = 1 To 3
- For c = 1 To 3
- If a <> b And b <> c And a <> c Then
- j = j + 1
- n = arr(i, 1)
- brr(i, j) = "'" & Mid(n, a, 1) & Mid(n, b, 1) & Mid(n, c, 1)
- End If
- Next c
- Next b
- Next a
- j = 0
- Next i
- [c1].Resize(UBound(arr), 6) = brr
- End Sub
复制代码 |