concatenate in combination
You are very welcome
--
Gary''s Student
"Erico Franco" <""ericofranco "@ ig.com." wrote:
Gary''s Student wrote:
Here is a litle VBA:
Sub Macro1()
Dim i, j, k As Integer
k = 1
For i = 1 To 5
For j = 1 To 5
Cells(k, 3) = Cells(i, 1) & Cells(j, 2)
k = k + 1
Next
Next
End Sub
i going to 5 is for column A and can be expanded
j going to 5 is for colmun B and can be expanded
Hi Gary,
thanks for your code and time!
regards
Erico
|