Quand on n'y est pas, on n'y est pas...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'
If Target.Count = 1 Then _
If Not Intersect(Target, Range("F14:F61")) Is Nothing And Target.Row Mod 8 <> 5 Then _
iRow = Target.Row: _
If WorksheetFunction.IsFormula(Target) = False Then Target.FormulaLocal = _
"=SI(ESTVIDE(C" & iRow & ");"""";E" & Choose((iRow Mod 8) + 1, 6, 7, 8, 9, 10, 1, 4, 5) & ")"
'
End Sub
A+