Sub test()
Aleatoir Sheets("Code aléatoire multiple de 5"), 5
Aleatoir Sheets("Code aléatoire multiple de 10"), 10
Aleatoir Sheets("Code aléatoire multiple de 10b"), 10, 1300
End Sub
Sub Aleatoir(Sht As Worksheet, Pas As Integer, Optional Strat As Integer = 0)
Dim Multi As New Collection, I As Integer, Rn As Integer
With Sht.Range("A1").CurrentRegion
For I = 1 To .Rows.Count - 1
Multi.Add Strat - IIf(Strat = 0, 0, Pas) + (I * Pas)
Next
Randomize Format(Timer, "0")
For I = 2 To .Rows.Count
Rn = Int(Multi.Count * Rnd + 1)
.Cells(I, "E") = "'" & Format(Multi(Rn), "0000")
Multi.Remove Rn
Next
End With
End Sub