Sub Ventil()
Dim Tablo, i%, k%, iR%, iC%, Nbre As Currency, o As Range
Tablo = Array(200, 100, 50, 20, 10, 5, 1, 0.5, 0.2, 0.1, 0.05)
For Each o In Selection
With o
Nbre = .Value
iC = .Column + 1
iR = .Row
End With
For i = 0 To UBound(Tablo)
k = Int(Nbre / Tablo(i))
Nbre = Nbre - k * Tablo(i)
Cells(iR, iC + i) = IIf(k > 0, k, "")
Next
Next
End Sub