Sub Inserer_Ligne()
If MsgBox("Copier la ligne n°" & ActiveCell.Row & " ?", vbYesNo) = vbYes Then
Rows(ActiveCell.Row).Copy
Rows(ActiveCell.Row).Insert Shift:=xlDown
Application.CutCopyMode = 0
On Error Resume Next 'si aucune SpecialCell
Rows(ActiveCell.Row).SpecialCells(xlCellTypeConstants, 23).ClearContents
End If
End Sub