View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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