(vba) loop concepts

[montecarlo2012]

Hello. what kind of reasoning I have to apply, to understand how from the simple loop code here:

  [SIZE=3][COLOR=#000000][FONT=Calibri]Sub looptest()<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]Dim i As Integer, j As Integer<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]  For i = 1 To 6<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]    For j = 1 To 6<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]Cells(i, j).Value = i * j<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]      Next j<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri] Next i<o:p></o:p>[/FONT][/COLOR][/SIZE]
[SIZE=3][COLOR=#000000][FONT=Calibri]End Sub<o:p></o:p>[/FONT][/COLOR][/SIZE]

how to populate a row with something like this:

2/B3:G20

3/B4:G21

4/B5:G22

5/B6:G23

6/B7:G24

7/B8:G25

<tbody>
</tbody>

is an excel recipe, or there are a logic explanation.

<tbody>
</tbody>

 

[oldbrewer]

in cells(1,1) (when i=1 and j=1) to get a 2 I+1 put this in AA1 ie cells(1,27)
to get a 3 I+2 put this in cells(1,28)
to get a 20 I+19 put this in cells(1,29)

then make cell AZ1 =concatenate(aa1,"/B",aa2,":g",aa3)

you now have 2/b3:g20 in AZ1

 

[montecarlo2012]

Thanks oldbrewer. When you said in cells you mean in the code the line cells (I, j) chance for the information you provide?. like cells(I+1,27). I am right or wrong?.