1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| Sub evaluation()
dim i as long
'Dim Note As Integer
'Dim Mention As String
'Note = Range("A2:A12") '----->>>>>> c'est là qu'il y a problème
for i = 2 to 12
If cells(i,1).value = 0 Then cells(i,2).value = "Nul"
If cells(i,1).value>= 1 And cells(i,1).value < 6 Then cells(i,2).value = "Moyen"
If cells(i,1).value>= 6 And cells(i,1).value< 11 Then cells(i,2).value = "Passable"
If cells(i,1).value>= 11 And cells(i,1).value< 16 Then cells(i,2).value = "Bien"
If cells(i,1).value>= 16 And cells(i,1).value< 20 Then cells(i,2).value = "Très Bien"
If cells(i,1).value= 20 Then cells(i,2).value = "Excellent"
next i
'Range("B2:B12") = Mention
End Sub |
Partager