Bonjour
A tester
Sub Entree()
If Application.CountA(Range("B5").Resize(1, 5)) <> 5 Then
MsgBox "La ligne " & Range("A5") & " n'est pas complétement remplie"
Else
Rows("5:5").Insert Shift:=xlDown
Rows("6:6").Copy
Rows("5:5").PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
Range("A5").FormulaR1C1 = "=R[1]C+1"
Range("B5").Select
End If
End Sub