Change length of For loop while in the loop

by

I did a simple test and found the same problem:

Sub Macro1()
    Dim x As Integer: x = 10

    For i = 1 To x
        If (i = 5) Then
            x = 15
        End If
    Next

    MsgBox (i)
End Sub

Looks like excel does precompile the limit of a for loop. You can change your loop to a while instead.

See this post

x = 2

While x <= lastRow
    cellDifference = Range("B" & (x)).Value - initialValue
    If Abs(cellDifference) > 1 Then
        'your code

        lastRow = lastRow + 1
    End If
    x = x + 1
Wend

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. Loop through files in a folder using VBA?
  4. How to error handle 1004 Error with WorksheetFunction.VLookup?
  5. How can Excel VBA open file using default application
  6. How to compare two entire rows in a sheet
  7. Run same excel macro on multiple excel files
  8. how to detect whether VBA excel found something?
  9. VBA : save a file with UTF-8 without BOM
  10. Excel tab sheet names vs. Visual Basic sheet names
  11. Saving a Excel File into .txt format without quotes
  12. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  13. Determine if cell contains data validation
  14. VBA – Range to jpg picture
  15. Fastest way to delete rows which cannot be grabbed with SpecialCells
  16. Combine multiple Excel workbooks into a single workbook
  17. Excel Macro, inserting internationally valid formula during run-time
  18. Sheet protection: UserInterFaceOnly gone
  19. VBScript – How to make program wait until process has finished?
  20. Making VBA Form TextBox accept Numbers only (including +, – and .)
  21. VBA Convert date to week number
  22. Inserting an Online Picture to Excel with VBA
  23. vba paste not working
  24. Continue For loop
  25. mac excel vba loop : from list & then export as pdf
  26. Can Advanced Filter criteria be in the VBA rather than a range?
  27. In Excel VBA, what is the way to check if the web page is fully loaded?
  28. Reading Web Pages using Excel VBA
  29. Excel VBA: auto click and open file from website
  30. VBA inheritance, analog of super

Leave a Comment