What VBA code would I use to concatenate cell A2 B2 in cell C2 and then have it Autofill down the column

Question

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.

Sub ConcatenateStrings()

    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

End Sub

Answer 1

1. Find the last row.
2. Write a formula to concatenate columns B and C.
3. Hard-code the formula results.

Sub Tester()
    Dim ws As Worksheet
    Set ws = ActiveSheet

    Dim lastRow As Long
    lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row
        
    With ws.Range("C2:C" & lastRow)
        .Formula = "=A2&"", ""&B2"
        .Value = .Value
    End With
End Sub