Function "&" with 2 columns

[calepp]

Hello!

I would like to use VBA for this but I don't know how to.

I have letters in the first column and numbers in the second one but there can be hundreds as there can be only one in each column. I want to have what's in the third column, I mean every combination possible between letters and numbers.

What can I do with VBA ?

Thanks for your help!



A
1
A1


B
2
A2


C

B1




B2




C1




C2

[p45cal]

Something like:
Set Colm1 = Range(Cells(1, "A"), Cells(Rows.Count, "A").End(xlUp))
Set Colm2 = Range(Cells(1, "B"), Cells(Rows.Count, "B").End(xlUp))
DestnRow = 0
'Colm1.Select
'Colm2.Select
For Each cll In Colm1.Cells
For Each celle In Colm2.Cells
DestnRow = DestnRow + 1
Cells(DestnRow, "C") = cll.Value & celle.Value
Next celle
Next cll
End Sub

[calepp]

Thanks a lot!