To exit your loop early you can use Exit For
If [condition] Then Exit For
More Related Contents:
- Excel VBA For Each Worksheet Loop
- Test or check if sheet exists
- How to copy Outlook mail message into excel using VBA or Macros
- For Loop not fully cycling in excel VBA [duplicate]
- Unique Random Numbers using VBA
- Populate unique values into a VBA array from Excel
- How to add a named sheet at the end of all Excel sheets?
- Closing Excel Application using VBA
- Delete Row based on Search Key VBA
- How to add a button programmatically in VBA next to some sheet cell data?
- What are the benefits of setting objects to “Nothing”
- How can I kill task manager processes through VBA code?
- VBA: Usage of parentheses for a method
- Fully reference a worksheet by codename
- Get Unicode characters with charcode values greater hex `FFFF`
- Excel macro – paste only non empty cells from one sheet to another
- The MacScript function is not working well in Office for Mac 2016! Any ideas?
- Pointers needed for speeding up nested loop macro in VBA
- ‘1004’: “The sort reference is not valid.”
- Select entire column in table using Excel VBA
- Create hyperlink to another sheet
- Reducing WithEvent declarations and subs with VBA and ActiveX
- Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
- Excel VBA – select multiple columns not in sequential order
- How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
- Application.WorksheetFunction.Match method
- Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
- Excel Hide/Show all tabs on Ribbon except custom tab
- Macros Not Showing Up in Macro Table
- Excel telling me my blank cells aren’t blank