Excel VBA While Loop – Inner Loops Explained
In this advanced Excel VBA lesson, we take While loops to the next level by introducing nested (inner) loops.
Instead of looping down a single column, you'll learn how to:
Loop across columns within a row
Then move to the next row and repeat
Debug While loops with control variables
Avoid common mistakes like forgetting to reset counters
We walk through printing values row-by-row and column-by-column, and show you how to fix logic errors that stop loops from progressing.
🔁 Looping Topics Covered:
Outer vs Inner loops
Row and column control variables
Avoiding infinite loops and logic bugs
Real use case with random Excel values
✅ Bonus Exercise: Try copying the values to another location in your sheet using the loop structure!
00:00 – Intro: Welcome back, let’s go deeper with loops
00:14 – Recap: Last time we looped through rows only
00:26 – Goal: Print values row-by-row, column-by-column
01:00 – Explaining row and column limits (Row 12, Column 4)
01:40 – Declaring maxRow and maxCol variables
02:20 – Why we use less-than condition in While loops
03:10 – Setting up starting points for row and column
04:00 – Building the outer While loop (row-based)
05:00 – Introducing the inner While loop (column-based)
06:00 – Printing each cell’s value using `Cells(row, column)`
07:00 – Common mistake: Forgetting to increment counters
08:00 – Tracing the loop logic with debug prints
09:00 – Logic bug: Why only Row 1 prints
10:00 – Dora moment: Can you find the error?
11:15 – Fixing the bug: Re-initialize column to 1
12:00 – Final result: Full table printed row by row
12:50 – Practice challenge: Copy data instead of printing
13:30 – Where to go next – insert values into cells
14:00 – Wrap-up: Free content, no ads
On this page of the site you can watch the video online Excel VBA While Loop – Inner Loops Explained with a duration of hours minute second in good quality, which was uploaded by the user Alex Luy 20 July 2018, share the link with friends and acquaintances, this video has already been watched 1,885 times on youtube and it was liked by 40 viewers. Enjoy your viewing!
