Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate | Excel Discussion (Misc queries) | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
Concatenate text and numbers? | Excel Worksheet Functions | |||
Concatenate Function will not work | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) |