Bonjour,
Essayez celle-ci:
Sub Remplissage_Colonne_I()
Application.ScreenUpdating = False
DerLig = Range("D" & Rows.Count).End(xlUp).Row
Range("I2:I" & DerLig).FormulaR1C1 = "=IF(RC[-5]="""","""",IF(OR(AND(R[-1]C[-5]>=1600,R[-1]C[-5]<=3600,RC[-5]>=1600,RC[-5]<=3600,LEN(R[-1]C[-5])=4,LEN(RC[-5])=4,R[-1]C[-5]<>"""",RC[-5]<>R[-1]C[-5]),AND(RC[-5]>=1600,RC[-5]<=3600,R[1]C[-5]>=1600,R[1]C[-5]<=3600,LEN(RC[-5])=4,LEN(R[1]C[-5])=4,R[1]C[-5]<>"""",RC[-5]<>R[1]C[-5])),0.5,""""))"
Range("I2:I" & DerLig).Value = Range("I2:I" & DerLig).Value
End Sub
Cdlt