Sub controlesaisie()
'
' controlesaisie Macro
'
'
Dim Lg, cel As Range, Plg As Range
Lg = Range("m2012").End(xlUp).Row + 1
Set Plg = Range("a" & Lg & ":d" & Lg & ",f" & Lg & ",i" & Lg & ",l" & Lg)
For Each cel In Plg
If cel = "" Then
cel.Activate
MsgBox (Cells(11, cel.Column) & Chr(10) & "Veuillez renseigner cette cellule!")
Exit Sub
End If
If WorksheetFunction.CountA(Plg) = 7 Then Range("m" & Lg) = "ok"
Next cel
End Su