Sub Macro1()
Dim i As Long, j As Long, m As Long, n As Long, k As Long, x As Long, Arr()
Dim sLetter As String, Counter As Long
Arr = Range(Cells(1, 1), Cells(5, 1)).Value
ReDim Arr2(1 To 25, 1 To 1)
For i = 1 To 5
For j = 1 To 5
x = x + 1
Arr2(x, 1) = Arr(i, 1) & Arr(j, 1)
Next
Next
k = 0
ReDim Arr3(1 To UBound(Arr2), 1 To 1)
For i = 1 To UBound(Arr2)
Counter = 0
For j = 1 To Len(Arr2(i, 1))
sLetter = Mid(Arr2(i, 1), j, 1)
If InStr(j + 1, Arr2(i, 1), sLetter, 1) > 0 Then
Counter = Counter + 1
Exit For
End If
Next
If Counter = 0 Then
k = k + 1
Arr3(k, 1) = Arr2(i, 1)
End If
Next
Cells(1, 2).Resize(k, 1).Value = Arr3
x = 0
ReDim Arr2(1 To 125, 1 To 1)
For i = 1 To 5
For j = 1 To 5
For m = 1 To 5
x = x + 1
Arr2(x, 1) = Arr(i, 1) & Arr(j, 1) & Arr(m, 1)
Next
Next
Next
k = 0
ReDim Arr3(1 To UBound(Arr2), 1 To 1)
For i = 1 To UBound(Arr2)
Counter = 0
For j = 1 To Len(Arr2(i, 1))
sLetter = Mid(Arr2(i, 1), j, 1)
If InStr(j + 1, Arr2(i, 1), sLetter, 1) > 0 Then
Counter = Counter + 1
Exit For
End If
Next
If Counter = 0 Then
k = k + 1
Arr3(k, 1) = Arr2(i, 1)
End If
Next
Cells(1, 3).Resize(k, 1).Value = Arr3
Erase Arr2
Erase Arr3
x = 0
ReDim Arr2(1 To 625, 1 To 1)
For i = 1 To 5
For j = 1 To 5
For m = 1 To 5
For n = 1 To 5
x = x + 1
Arr2(x, 1) = Arr(i, 1) & Arr(j, 1) & Arr(m, 1) & Arr(n, 1)
Next
Next
Next
Next
k = 0
ReDim Arr3(1 To UBound(Arr2), 1 To 1)
For i = 1 To UBound(Arr2)
Counter = 0
For j = 1 To Len(Arr2(i, 1))
sLetter = Mid(Arr2(i, 1), j, 1)
If InStr(j + 1, Arr2(i, 1), sLetter, 1) > 0 Then
Counter = Counter + 1
Exit For
End If
Next
If Counter = 0 Then
k = k + 1
Arr3(k, 1) = Arr2(i, 1)
End If
Next
Cells(1, 4).Resize(k, 1).Value = Arr3
End Sub
|