VB code for joining column data.
 

Hi,

I want to join columnL & J with result in ColumnM.
It should join till each value found in column J.

How to do it wth VB?

VB code for joining column data.
 

When you say "Join" I presume you want to simply concatenate them.

LastRow = (You - Know - How - From - Your - Other - Post)

For i = 1 To LastRow
Cells(i, 13) = Cells(i, 12) & Cells(i, 10)
Next i


"Sinner" wrote:

Hi,

I want to join columnL & J with result in ColumnM.
It should join till each value found in column J.

How to do it wth VB?

VB code for joining column data.
 

On Apr 9, 5:27*pm, Charlie wrote:
When you say "Join" I presume you want to simply concatenate them.

LastRow = (You - Know - How - From - Your - Other - Post)

For i = 1 To LastRow
Cells(i, 13) = Cells(i, 12) & Cells(i, 10)
Next i



"Sinner" wrote:
Hi,

I want to join columnL & J with result in ColumnM.
It should join till each value found in column J.

How to do it wth VB?- Hide quoted text -

- Show quoted text -

Thanks. With little modification working ok.