VBA list question

Originally Posted by torachan

Dim i As Long
Dim j As Long
Dim k As Long
Dim l As Long
For i = 1 To 26
For j = 1 To 26
For k = 1 To 26
l = l + 1
Range("D" & l) = Range("A" & i) & "|" & Range("B" & j) & "|" & Range("C" & k)
Next k
Next j
Next i

Thanks so much torachan, that is amazing.

I don't know if I need to open another thread, but I wanted to know how I could get all possible combinations of 2 columns and 3 columns, not sure if this is possible, I was trialing adding a blank row at the end and extending the range out to 1 - 27?