Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|