The code below, which I am using to combine LastName and FirstName from columns A and B into column C even though I am a novice at VBA, works for each individual cell. The last row might change each time, so how can I get it to repeat for a range of cells?
The code I used, which works for rows A2 and B2, should continue for rows A3, B3, and so on along the rows, with the last row updating as each report is generated.
Dim StringOne As String
Dim StringTwo As String
Dim StringThree As String
StringOne = Range("A2").Value
StringTwo = Range("B2").Value
Range("C2").Value = StringOne & ", " & StringTwo