AAP
Member
Hi Everyone, I want to concatenate two different columns into a new column. Column 44 and Column 35 should be merged into column 45. My sheet contains 1000000 rows, the For Loop works code works fine as given below. But it is not efficient to do the task quickly. I am missing range or array to include in concatenation so that i work quickly. Any advice please
[Cells(2, 45).Select
For i = 2 To LastRow
ActiveCell.Value = Cells(i, 44).Value & Cells(i, 35).Value
ActiveCell.Offset(1, 0).Select
Next i]
[Cells(2, 45).Select
For i = 2 To LastRow
ActiveCell.Value = Cells(i, 44).Value & Cells(i, 35).Value
ActiveCell.Offset(1, 0).Select
Next i]