Combination Sequencer Using Tables

[HotNumbers]

Is is possible to use VB to generate all possible combinations from 3 different list . Sample of small data below:

Excel Workbook
	A	B	C	D	E	F	G
1	Geo	Channel	Type			Solution
2	AD	18	AF07			AD18AF07
3	AE	26	AN62			AE26AN62
4	AF	30	AF30			AF30AF30
5	AG	31
6	AI
7	AL
8	AM
9	AN
10	AO
11	AQ
12	AR
13	AS
14	AT
15	AU
16	AW
17
Sheet1

Excel 2007

Cell Formulas
Range	Formula
F2	=CONCATENATE(A2,B2,C2)
F3	=CONCATENATE(A3,B3,C3)
F4	=CONCATENATE(A4,B4,C4)

 

[HotNumbers]

For those who like to know... here is the solution

Sub aaa()
cntr = 1
For Each ce1 In Range("a2:a" & Cells(Rows.Count, "A").End(xlUp).Row)
For Each ce2 In Range("b2:b" & Cells(Rows.Count, "B").End(xlUp).Row)
For Each ce3 In Range("c2:c" & Cells(Rows.Count, "C").End(xlUp).Row)
For Each ce4 In Range("d2:d" & Cells(Rows.Count, "D").End(xlUp).Row)
Range("e1").Offset(cntr, 0).Value = ce1 & ce2 & ce3 & ce4
cntr = cntr + 1
Next ce4
Next ce3
Next ce2
Next ce1
End Sub

 

[shg]

There's a formula-based solution at http://www.box.net/shared/ubd28tissi