Sub spreadDeCredit22() Dim k, j As Long Dim spot_1 As Double Dim spot_2 As Double Dim somme As Single Dim diff As Double Dim i As Integer k = Worksheets("Feuil1").Cells(Rows.Count, 1).End(xlUp).Row somme = 0 For i = 0 To k If Worksheets("Feuil1").Cells(i + 6, 16).Value Like "*AAA*" Then spot_1 = Worksheets("Feuil1").Cells(i + 6, 10).Value spot_2 = Worksheets("Feuil1").Cells(i + 6, 11).Value diff = Abs(spot_1 - spot_2) / 100 somme = somme + diff j = j + 1 End If Next i Cells(6, 8).Value = somme / j End Sub
Sub spreaDeCredit() Dim k As Long Dim spot_1 As Double Dim spot_2 As Double Dim somme As Single Dim diff As Double Dim Occurence As Integer k = Worksheets("Feuil1").Cells(Rows.Count, 1).End(xlUp).Row For i = 0 To k - 6 If Worksheets("Feuil1").Cells(i + 6, 16).Value Like "*AAA*" Then Occurence = Occurence + 1 spot_1 = Worksheets("Feuil1").Cells(i + 6, 10).Value spot_2 = Worksheets("Feuil1").Cells(i + 6, 11).Value diff = Abs(spot_1 - spot_2) somme = somme + diff End If Cells(6, 8).Value = somme / Occurence Next End Sub
Cells(6, 8).Value = somme / Occurence
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim k, j As Longne signifie pas que k et j seront des Long : uniquement j, k sera un Variant
Dim k As Long, j As Long