gssachin
Board Regular
- Joined
- Nov 14, 2013
- Messages
- 155
Hi
I have to concatenate 2 column i.e. d2 & e2 (d2&"."&e2) and same has to be copy upto last row as per F column. I write following macro but its taking 2 much time to execute. Can anybody tell faster way ???
sub macro 1
lastRow = Sheet1.Range("F" & Rows.Count).End(xlUp).Row
For i = 2 To lastRow
Cells(i, 7) = (Cells(i, 4) & "." & Cells(i, 5))
Next i
end sub
I have to concatenate 2 column i.e. d2 & e2 (d2&"."&e2) and same has to be copy upto last row as per F column. I write following macro but its taking 2 much time to execute. Can anybody tell faster way ???
sub macro 1
lastRow = Sheet1.Range("F" & Rows.Count).End(xlUp).Row
For i = 2 To lastRow
Cells(i, 7) = (Cells(i, 4) & "." & Cells(i, 5))
Next i
end sub