[COLOR=DarkSlateGray][B]Private Sub Worksheet_Change(ByVal Target As Range)
Dim plg, zon As Range
Set zon = [C4:C37] [COLOR=DarkOrange]'= plage de travail, à adapter.[/COLOR]
Set plg = Intersect(Target, zon)
If Not plg Is Nothing Then
With Intersect(Selection, zon)
With Application: .ScreenUpdating = 0: .Calculation = -4135: .EnableEvents = 0: End With
If .Count > 1 Then .FillDown
With Application: .EnableEvents = 1: .ScreenUpdating = 0: .Calculation = -4105: End With
End With
End If
End Sub[/B][/COLOR]