Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub pret() Dim Mensualite As Currency, Emprunt As Currency, DateD As Date, Ws As Worksheet Set Ws = [Feuil1] ActiveSheet.Name = "Simulation_Emprunt" With Ws 'On réinitialise le tableau i = 10 Do While Cells(i, 1) <> "" Cells(i, 1).EntireRow.Clear i = i + 1 Loop 'On charge les variables Emprunt = .Range("B3") Mensualite = .Range("E3") Taux_annuel = .Range("B5") DateP = .Range("B6") i = 10 'On initialise le tableau .Cells(i, 1) = DateAdd("m", 1, Range("B6")) .Cells(i, 2) = Emprunt .Cells(i, 3) = Mensualite .Cells(i, 4) = Emprunt * (Taux_annuel / 100) / 12 .Cells(i, 5) = Mensualite - .Cells(i, 4) .Cells(i, 6) = .Cells(i, 2) - .Cells(i, 5) 'on commence la boucle Do While .Cells(i, 6) > 0.1 i = i + 1 .Cells(i, 1) = DateAdd("m", 1, .Cells(i - 1, 1)) .Cells(i, 2) = .Cells(i - 1, 6) .Cells(i, 3) = Mensualite .Cells(i, 4) = .Cells(i, 2) * (Taux_annuel / 100) / 12 .Cells(i, 5) = Mensualite - .Cells(i, 4) .Cells(i, 6) = .Cells(i, 2) - .Cells(i, 5) Loop End With End Sub