VBA – how to conditionally skip a for loop iteration

by

VBA does not have a Continue or any other equivalent keyword to immediately jump to the next loop iteration. I would suggest a judicious use of Goto as a workaround, especially if this is just a contrived example and your real code is more complicated:

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

If that is really all of your code, though, @Brian is absolutely correct. Just put an Else clause in your If statement and be done with it.

More Related Contents:

  1. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  2. Vba macro to copy row from table if value in table meets condition
  3. Change length of For loop while in the loop
  4. Continue For loop
  5. delete Autofilter Field resullt using the header Name
  6. How can I call a macro which contains a loop but only run one iteration of that loop?
  7. Somehow it’s not copying [closed]
  8. Get list of sub-directories in VBA
  9. So, I have 6 “master” files to then divide into 40 separate files
  10. Application.Match gives type mismatch
  11. What does the Call keyword do in VB6?
  12. Count and Highlight keywords within phrases
  13. How to securely store Connection String details in VBA
  14. How to type Unicode currency character in Visual Basic Editor
  15. Detect merged cells in VBA Excel with MergeArea
  16. Hash Table/Associative Array in VBA
  17. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  18. Parse HTML content in VBA
  19. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  20. Repeating random variables in VBA
  21. Is “Value” actually the default property of the Range object?
  22. Excel VBA: AutoFill Multiple Cells with Formulas
  23. Text file in VBA: Open/Find Replace/SaveAs/Close File
  24. VBA.Find and adding a value
  25. How to continue the code on the next line in VBA
  26. Excel VBA Userform – Execute Sub when something changes
  27. Getting Excel to refresh data on sheet from within VBA
  28. Finding first blank row, then writing to it
  29. How do I get a list of unique values from a range in Excel VBA?
  30. How to get selected value in multicolumn listbox

Leave a Comment