For Loop - Excel VBA Training

Home More Videos

In the last training video we had learnt how to automate calculations using a 'do while' loop. When do we use a 'for next' loop in Microsoft Excel.  The 'for' loop is used to automate calculations if you know the exact number of rows or cells where you wish to perform calculations. We can then easily loop from rows 2 to 5 or whatever. The for loop has many variations but we describe in the training video the most universal type. The other variations can be easily understood once you master this one. Of course, you can not only use the looping process to perform calculations, you can also use it to find duplicates, create reports or highlight specific data as in conditional formatting.