Sub Concatenate_Example3()
Dim i As Integer
For i = 1 To 50
Cells(i, 16).Value = Cells(i, 10) & "-" & Cells(i, 11) & "-" & Cells(i, 12)
Cells(i, 17).Value = "??????" & Cells(i, 1)
Next i
End Sub
hello everyone,
how to used till last used row instead 1 to 50
sometimes last used row is 15
sometimes last used row is 55
Bookmarks