Sub test()
'Extraire Musique
Dim Temp()
If I > 1 Then
Musiques = Musique(Cells(Lig + I, "M").Value)
Temp = Split(Musiques, " ")
If UBound(Temp) < 5 Then ReDim Preserve Temp(5)
For K = 0 To IIf(UBound(Temp) > 5, 6, UBound(Temp))
Cells(Lig + I, 14 + K) = IIf(Temp(K) = "0", 10, IIf(Temp(K) = "", 0, Temp(K)))
Next K
End If
End Sub