Sub Calcul_moyenne_etendue()
Sheets("Final").Range("A5:E" & Sheets("Final").Range("A65500").End(xlUp).Row).ClearContents
Application.ScreenUpdating = False
DL = Sheets("BDD").Range("A65500").End(xlUp).Row
Set F = Sheets("BDD")
With Sheets("Final")
.Activate
For L = 5 To DL
.Cells(L, "A") = F.Cells(L, "A")
.Cells(L, "B") = (F.Cells(L, "B") + F.Cells(L, "H") + F.Cells(L, "N")) / 3
.Cells(L, "C") = (F.Cells(L, "D") + F.Cells(L, "J") + F.Cells(L, "P")) / 3
.Cells(L, "D") = (F.Cells(L, "E") + F.Cells(L, "K") + F.Cells(L, "Q")) / 3
.Cells(L, "E") = Application.Max(F.Cells(L, "E"), F.Cells(L, "K"), F.Cells(L, "Q")) _
- Application.Min(F.Cells(L, "E"), F.Cells(L, "K"), F.Cells(L, "Q"))
Next L
End With
End Sub