bonjour le forum
quelqu'un serait me simplifier le programme vba qui suit, car la plus part des ligne se ressemble. merci
If xxx > num1 And xxx < num2 Or xxx > num1 And Range("ak14") = 1 Then
For ret = 1 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num2 And xxx < num3 Or xxx > num2 And Range("ak14") = 2 Then
For ret = 2 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num3 And xxx < num4 Or xxx > num3 And Range("ak14") = 3 Then
For ret = 3 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num4 And xxx < num5 Or xxx > num4 And Range("ak14") = 4 Then
For ret = 4 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num5 And xxx < num6 Or xxx > num5 And Range("ak14") = 5 Then
For ret = 5 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num6 And xxx < num7 Or xxx > num6 And Range("ak14") = 6 Then
For ret = 6 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num7 And xxx < num8 Or xxx > num7 And Range("ak14") = 7 Then
For ret = 7 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num8 And xxx < num9 Or xxx > num8 And Range("ak14") = 8 Then
For ret = 8 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num9 And xxx < num10 Or xxx > num9 And Range("ak14") = 9 Then
For ret = 9 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num10 And xxx < num11 Or xxx > num10 And Range("ak14") = 10 Then
For ret = 10 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num11 And xxx < num12 Or xxx > num11 And Range("ak14") = 11 Then
For ret = 11 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
quelqu'un serait me simplifier le programme vba qui suit, car la plus part des ligne se ressemble. merci
If xxx > num1 And xxx < num2 Or xxx > num1 And Range("ak14") = 1 Then
For ret = 1 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num2 And xxx < num3 Or xxx > num2 And Range("ak14") = 2 Then
For ret = 2 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num3 And xxx < num4 Or xxx > num3 And Range("ak14") = 3 Then
For ret = 3 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num4 And xxx < num5 Or xxx > num4 And Range("ak14") = 4 Then
For ret = 4 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num5 And xxx < num6 Or xxx > num5 And Range("ak14") = 5 Then
For ret = 5 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num6 And xxx < num7 Or xxx > num6 And Range("ak14") = 6 Then
For ret = 6 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num7 And xxx < num8 Or xxx > num7 And Range("ak14") = 7 Then
For ret = 7 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num8 And xxx < num9 Or xxx > num8 And Range("ak14") = 8 Then
For ret = 8 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num9 And xxx < num10 Or xxx > num9 And Range("ak14") = 9 Then
For ret = 9 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num10 And xxx < num11 Or xxx > num10 And Range("ak14") = 10 Then
For ret = 10 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If
If xxx > num11 And xxx < num12 Or xxx > num11 And Range("ak14") = 11 Then
For ret = 11 To 11
Range("ak" & ret) = Range("ak" & ret) + 1
If Range("ak" & ret + 1) = "" Then Exit For
Next
End If