Hi All,
I'm using this code from another thread, but I want it to copy data down a row instead over a column. I tried this code, but it didn't work! Could you help me fix it?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim LC As Long
LC = Cells(1, Rows.Count).End(xlToDown).Row
    If Not Intersect(Target, Range("A2:J2")) Is Nothing Then
        Application.EnableEvents = False
        Range("A2:J2").Copy Cells(1, LC + 1)
        Application.EnableEvents = True
    End If
End Sub
Should be easy for you Excel programming experts!

Thanks in advance!