Private Sub Worksheet_Activate()
Dim T(), SgModèle As SsGroup, SgNoSérie As SsGroup, _
SgNoParc As SsGroup, SgNoOR As SsGroup, L As Long
ReDim T(1 To 500, 1 To 4)
For Each SgModèle In GroupOrg(Feuil2.[A2], 8, 9, 5, 29)
For Each SgNoSérie In SgModèle.Contenu
For Each SgNoParc In SgNoSérie.Contenu
For Each SgNoOR In SgNoParc.Contenu
L = L + 1
T(L, 1) = SgModèle.Id
T(L, 2) = SgNoSérie.Id
T(L, 3) = SgNoParc.Id
T(L, 4) = SgNoOR.Count
Next SgNoOR, SgNoParc, SgNoSérie, SgModèle
Me.[B7].Resize(500, 4).Value = T
End Sub