Dim arr, brr(3), r
Sub x()
arr = Range("A1").Resize(Range("A65536").End(xlUp).Row)
r = 0: Call com(1, 0)
End Sub
Sub com(k As Integer, n As Integer)
If n < 3 Then
For i = k To UBound(arr) - 2 + n
brr(n) = arr(i, 1)
Call com(i + 1, n + 1)
Next
Else
r = r + 1
Cells(r, 2).Resize(1, 3) = brr
End If
End Sub
Dim arr, brr(3), r
Sub x()
arr = Range("A1").Resize(Range("A65536").End(xlUp).Row)
r = 0: Call com(1, 0)
End Sub
Sub com(k As Integer, n As Integer)
If n < 3 Then
For i = k To UBound(arr) - 2 + n
brr(n) = arr(i, 1)
Call com(i + 1, n + 1)
Next
Else
r = r + 1
Cells(r, 2).Resize(1, 3) = brr
End If
End Sub