| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill column from data (code) in column next to it | Excel Worksheet Functions | |||
| Joining up data points | Charts and Charting in Excel | |||
| Joining rows with different data | Excel Programming | |||
| joining data points on graph | Charts and Charting in Excel | |||
| Joining data points on a line chart | Charts and Charting in Excel | |||
Linear Mode
