VBA Code formula

[adamsm]

Hi,

How could I make the following code to insert row when the user double clicks column E and copies the contents from C,D & K

ANy help on this would be kindly appreciated.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True   'Eliminate Edit status due to doubleclick
    Target.Offset(1).EntireRow.Resize(1).Insert
    Target.EntireRow.Copy Target.EntireRow.Offset(1).Resize(1).EntireRow
    On Error Resume Next
    Target.Offset(1).EntireRow.Resize(1).SpecialCells(xlConstants).ClearContents
    On Error GoTo 0
End Sub