Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim RangeToCopy As Excel.Range
Set RangeToCopy = Target.Resize(1, 12)
Dim LastCell As Long
LastCell = Cells(Rows.Count, "A").End(xlUp).Row + 2
RangeToCopy.Copy Destination:=ActiveSheet.Range("A" & LastCell)
Cancel = True
End Sub