mercii bcpp
Cells(i, 5) = Cells(i, 4) / Cells(i, 3)
sa me donne erreur 13
Sub Taux_Accp()
Dim Sinistre_Accepte As Range
Dim Sinistre_Declare As Range
Dim DernLigne As Long
Dim i As Integer
With Worksheets("Feuil4")
DernLigne = .Range("A" & .Rows.Count).End(xlUp).Row
Set Sinistre_Accepte = .Range("D2:D" & DernLigne)
Set Sinistre_Declare = .Range("C2:C" & DernLigne)
End With
For i = 1 To DernLigne
Cells(i, 5) = Cells(i, 4) / Cells(i, 3)
Next i
End Sub