vba continue for each loop

The solution for “vba continue for each loop” can be found here. The following code will assist you in solving the problem.

For i = LBound(Schedule, 1) To UBound(Schedule, 1)
If (Schedule(i, 1) < ReferenceDate) Then PrevCouponIndex = i Goto NextIteration ' <- Key code End If DF = Application.Run("SomeFunction"....) PV = PV + (DF * Coupon / CouponFrequency) '....' 'a whole bunch of other code you are not showing us' '....' NextIteration: ' <- Key code Next

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts