Excel Macro Mastery – How You Can Write VBA Like a Professional in 15 Simple Steps by Paul Kelly

Author:Paul Kelly [Kelly, Paul]
Language: eng
Format: azw3
Published: 2014-11-24T16:00:00+00:00

‘ Same as above except condition evaluates at the end

iRow = 1

Do

ThisWorkbook.Worksheets("Sheet1").Cells(iRow, 1) = iRow

iRow = iRow + 1

Loop While ThisWorkbook.Worksheets("Sheet1").Cells(iRow, 1) <> “”

End Sub

The two loops in the example are the same except for the placement of the While Condition. The difference between them is subtle. The second one will run at least once.

Notice that you have to maintain your own count here by adding 1 to iRow each time. Make sure your condition will eventually turn false or you will end up with an Infinite Loop (If this happens then use Ctrl Break to exit).

Notice also these loops are exactly the same as the For Loop example with the Exit For. The reality is that you can use a For Loop for almost everything you do in VBA. This is because most of what you do in VBA requires reading through cells and For Loops are best suited for this. The other loops are useful to know because you will see them in legacy code.

In other languages While loops are very useful. In VBA you tend to use loops with cells or sheet which is why the For Loop is so dominant.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.