| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
quicker cell concatenation
Dear experts,
I want to fill in a range (column) with concatenation data from other 4 columns. The number of rows is quite big so it takes a while before vba can finish the task. My code looks like For i = 1 to LastRow Cells(i, 7)=Cells(i,1) & Cells(7,2) & Cells(i,3) & Cells(1,4) & Cells(i,5) & Cells(i,6) Next i Is there another way to do this more quickly, maybe playing with ranges? Thanks a lot for your advice. Kind regards -- Valeria |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse Concatenation (Splitting Single Cell Data into Multiple Ce | Excel Discussion (Misc queries) | |||
| Return to 1st cell in next line in multi-column list for quicker e | Excel Worksheet Functions | |||
| dynamic rows: cell value concatenation | Excel Discussion (Misc queries) | |||
| quicker copydown | Excel Programming | |||
| Cell problems - need a quicker way. | Excel Worksheet Functions | |||
Threaded Mode
