Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Application.ScreenUpdating = False
On Error Resume Next
With ListObjects(1).Range.Offset(1)
If Intersect(Target(1).EntireRow, .Cells) Is Nothing Then
Target(1).EntireRow.Insert
Else
Target(1).EntireRow.Insert
ListObjects(1).Resize .Rows(0).Resize(.Rows.Count) 'redimensionnement du tableau
Exit Sub
End If
End With
With Target(-1, 1).EntireRow
.Copy .Rows(2) 'copier-coller
.Rows(2).SpecialCells(xlCellTypeConstants) = ""
End With
End Sub