Cocatenation using VBA

C

CLamar

I have two columns of data that are in an excel wksht, and I want to join the
two columns together and put it into a listbox. Can anyone suggest a method
of doing this.

Thanks
C Lamar
 
J

jetted

Hi Clamar

This will start you for the concatenate
Sub conc_colb_and_colc()
rowcount = Cells(Cells.Rows.Count, "a").End(xlUp).Row
For i = 2 To rowcount
val1 = Range("b" & i).Value 'assuming data is column b
val2 = Range("c" & i).Value 'assuming data is column c
Range("d" & i).Select 'store in column d
ActiveCell.Value = val1 & " " & val2
Next

End Su
 
Top