Bonjour,
Sub TiragePourcent()
Dim T(), n%, i%, x%, tx0$, tx1$, k$
n = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To n
tx0 = tx0 & ChrW(i + 32)
Next i
n = Int(n / 100 * ActiveSheet.Range("E6"))
Randomize
For i = 1 To n
x = Int(Len(tx0) * Rnd + 1)
k = Mid(tx0, x, 1)
tx1 = tx1 & k: tx0 = Replace(tx0, k, "")
Next i
ReDim T(n - 1, 0): n = 0
Application.ScreenUpdating = False
With ActiveSheet
.Range("E11:E300").ClearContents
For i = 1 To Len(tx1)
x = AscW(Mid(tx1, i, 1)) - 32
T(n, 0) = .Cells(x, 1)
n = n + 1
Next i
.Range("E11").Resize(n).Value = T
End With
End Sub
Cordialement.