Loops and Arrays in Excel VBA

A loop is used in Microsoft Excel to repeat a piece of code, while an array is a group of variables with the same data type and name. This note is an introduction to different types of loops and their use with arrays in Excel Visual Basic for Applications (VBA), with brief definitions and examples. Loops types included are for-next, for-each, do while (do until), do-loop (with while and until), and nested loops. For arrays, the note presents static and dynamic arrays with examples.