Cocatenation using VBA
 

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

Cocatenation using VBA
 

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 Sub


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=556581