Question : vba next for loop early
Answered by : super-sable-mndlsajlvriw
For i = LBound(Schedule, 1) To UBound(Schedule, 1) If (Schedule(i, 1) < ReferenceDate) Then PrevCouponIndex = i Goto NextIteration End If DF = Application.Run("SomeFunction"....) PV = PV + (DF * Coupon / CouponFrequency) '....' 'a whole bunch of other code you are not showing us' '....' NextIteration:
Next
Source : https://stackoverflow.com/questions/8680640/vba-how-to-conditionally-skip-a-for-loop-iteration | Last Update : Wed, 30 Jun 21