Hello everybody!
I have this macro which concatenates cell L2 and M2 and paste the result in W2. then stops.
My question is how to make this macro to run for the entire columns(L:L & M:M = W:W)? I want to mention that my columns may contain blanks and the sheet is monthly updated (from scracth) and i'm seeking the macro to adapt to the nr of rows. Can you please help me? Thank you!
Dim String1 As String
Dim String2 As String
Dim full_string As String
String1 = Cells(2, 12).Value
String2 = Cells(2, 13).Value
Cells(2, 23).Value = String1 + String2
I have this macro which concatenates cell L2 and M2 and paste the result in W2. then stops.
My question is how to make this macro to run for the entire columns(L:L & M:M = W:W)? I want to mention that my columns may contain blanks and the sheet is monthly updated (from scracth) and i'm seeking the macro to adapt to the nr of rows. Can you please help me? Thank you!
Dim String1 As String
Dim String2 As String
Dim full_string As String
String1 = Cells(2, 12).Value
String2 = Cells(2, 13).Value
Cells(2, 23).Value = String1 + String2