You can use a GoTo
:
Do
'... do stuff your loop will be doing
' skip to the end of the loop if necessary:
If <condition-to-go-to-next-iteration> Then GoTo ContinueLoop
'... do other stuff if the condition is not met
ContinueLoop:
Loop
More Related Contents:
- For Each loop: Some items get skipped when looping through Outlook mailbox to delete items
- What is the most efficient/quickest way to loop through rows in VBA (excel)?
- VBA – how to conditionally skip a for loop iteration
- Vba macro to copy row from table if value in table meets condition
- Change length of For loop while in the loop
- to make this code simpler
- Not looping through for loop – javascript
- How to compare variables in a loop, java
- How to do for loop through all items of a list except the first [duplicate]
- How to create and write to a txt file using VBA
- Save text file UTF-8 encoded with VBA
- Outlook VBA – Run a code every half an hour
- Excel VBA deleting rows in a for loop misses rows
- Can I iterate through all Outlook emails in a folder including sub-folders?
- Download attachment from Outlook and Open in Excel
- Embed picture in outlook mail body excel vba
- How to check for empty array in vba macro [duplicate]
- Where does VBA Debug.Print log to?
- VBA Adding a class to a collection [duplicate]
- What is the function of FormulaR1C1?
- Rounding a number to the nearest 5 or 10 or X
- Post increment operator not incrementing in for loop [duplicate]
- How to send files via HTTP_POST with Excel using VBA?
- VBA to open Excel hyperlink does not work when hyperlink generated with a formula
- Converting for loops to while loops in python
- How to Add Date Picker To VBA UserForm
- How to create dynamic variable names VBA
- Is it possible to make a `for` loop without an iterator variable? (How can I make make code loop a set number of times?)
- Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
- How do I get a list of unique values from a range in Excel VBA?