Sub Compte()
Dim T0, DL&, L&, i&: T0 = Timer
[I:J].ClearContents: [I3] = "N° de carte": [J3] = "Région"
Application.ScreenUpdating = False
DL = [A1000000].End(xlUp).Row
ReDim T(1 To Cells(DL, "C"), 1 To 2)
For L = 4 To DL
Premier = Cells(L, "B"): Dernier = Cells(L, "C"): Region = Cells(L, "A")
For i = Premier To Dernier
T(i, 1) = i: T(i, 2) = Region
Next i
Next L
[I4].Resize(UBound(T, 1), UBound(T, 2)) = T
[I1] = "Temps éxécution : " & Round(Timer - T0, 3) & " s"
End Sub