Home VBA Multiple Loops in Excel VBA

Multiple Loops in Excel VBA

In this article we are going to learn how to use multiple loops in VBA. We are going to use the For Next Loop.

To add a command button click on “Insert” and then select “Command Button” from ActiveX group.

Create a command button.

Write click on the command button and Select “View Code“.

select view code

Write this line of code. After writing the code, close the window by clicking on the red X button on the top left of the screen.

Dim i As Integer, j As Integer
For i=1 To 1 to 6 
For j=1 To 2
Cells (i, j).Value=100
Next j
Next i

vba code

Click on the command button to see this result.

That’s it!

Template

You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References