Horje
vba continue for each loop Code Example
vba continue for each loop 
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
Source: stackoverflow.com



Vb

Related
vba get text file content Code Example vba get text file content Code Example
excel insert blank row for value change in column Code Example excel insert blank row for value change in column Code Example
extract word in a text in excel Code Example extract word in a text in excel Code Example
extract the nth word from a text string Code Example extract the nth word from a text string Code Example
excel vba how to reset usedrange Code Example excel vba how to reset usedrange Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje