What does the To and Step mean in VBA?

by

from high number To 1 adding (-1) each iteration

Note: It’s adding because + AND - in mathematical logic evaluate to a -

If rows = 10 then

for i = 10 to 1 step -2 would mean loop back from 10 to 1 subtracting 2 from the i in each loop cycle.

adding a Debug.Print i inside the loop may give you a better clue.

Note: turn ON the Immediate Window hitting CTRL+G or View => Immediate Window from the VBE menu bar

enter image description here

An example loop increasing by 3 on each cycle.

for i = 1 to 10 step 3
    debug.print i 
next i

enter image description here

Usage

The step-back technique is mostly used when deleting rows from a spreadsheet.

To see the logic in practice see the following

More Related Contents:

  1. VBA code takes long time to execute in excel
  2. VBA, ADO.Connection and query parameters
  3. Is it possible to pass parameters programmatically in a Microsoft Access update query?
  4. Hidden features of VBA
  5. What is the lifetime of a global variable in excel vba?
  6. Difference between Visual Basic 6.0 and VBA
  7. VBA: Selecting range by variables
  8. How to check for empty array in vba macro [duplicate]
  9. Use autofilter on more than 2 criteria
  10. Calling a Sub in VBA
  11. Open an html page in default browser with VBA?
  12. MS Access VBA Error: Run time error ’70’ Permission Denied
  13. Compiler Error: User-defined types not defined
  14. Is it better to use ADO or DAO in Access 2007?
  15. Open a workbook using FileDialog and manipulate it in Excel VBA
  16. Vba Excel do vlookup from a closed file
  17. excel hyperlink to nothing
  18. Use getElementById on HTMLElement instead of HTMLDocument
  19. Vba macro to copy row from table if value in table meets condition
  20. Is there an equivalent to Thread.Sleep() in VBA
  21. Can I simultaneously declare and assign a variable in VBA?
  22. How to get logged-in user’s name in Access vba? [duplicate]
  23. Remove double quotation from write statement in vba
  24. Meaning of .Cells(.Rows.Count,”A”).End(xlUp).row
  25. Defaulting a folder for FileDialog in VBA
  26. Missing VBA compiler message for wrong method name
  27. User Defined Type (UDT) as parameter in public Sub in class module (VB6)
  28. How do I loop an excel 2010 table by using his name & column reference?
  29. Is there a way to make UDF that gives a description like the native Excel functions have when user clicks the Fx button?
  30. How to improve the speed of VBA macro code?

Leave a Comment