Sub Bouton1_QuandClic()
Dim c As Range
For Each c In Range('bx51:bx55')
If c = 0 Then c.Offset(0, 1) = 'N'
Next c
End Sub
'___________________________________________________________
Sub Bouton2_QuandClic()
Dim c As Range
For Each c In Range('a1:a' & Range('a65536').End(xlUp).Row)
Select Case c
Case 5, 10, 15, 20, 25, 30, 35, 40, 45, 50
c.Offset(0, 1) = 'E'
Case 4, 9, 14, 19, 24, 29, 34, 39, 44, 49
c.Offset(0, 1) = 'F'
End Select
Next c
End Sub