VBA - For Loops

For loops run for a discrete number of iterations. They have a variable that changes for each iteration of the loop.

Here is a basic example of a simple for loop.


This outputs this:


For each iteration of the loop the variable changes from 1 up to to 10.




Related Sections

Python - Learn the python from the basics up. This fast track example code course will get you creating powerful python programs in no time.



Must Read Articles


VBA and Microsoft Excel - Getting the most out of excel with VBA programming
VBA and Microsoft Word - Getting the most out of word with VBA programming
Application Object - Using the applications features in your code.
Installing VBA and First Program - What do you need to start using visual basic application VBA.