Efficient way to for a For loop using two numbers?

[Damein]

Sorry for the poor title, I couldn't think of a better way to handle this.

Alright, so I have an array that has 24 items. I need to plug this into an Excel sheet.

The problem is, the Excel cells start at 8. So I can't do a simple For loop using $i as the count to move through the cells.

So I need a way to fill in the cells like this.

For $i = 1 To 24
    _ExcelWriteCell($oExcel, $InitialVolts[$i][1], 8, 2) ; Write Customer
Next

But where the 8 goes up +1 each time. I assume with some logical math I could get this to work.. but I hate math and I figured there might be a more efficient way to handle it.

Thanks!

Solved using

$Count = 7

For $i = 1 To 24
    $Count += 1
    _ExcelWriteCell($oExcel, $InitialVolts[$i][1], $Count, 2) ; Write Customer
Next

Edited March 2, 2014 by Damein

[guinness]

Create a variable that holds 8 and increment by 1 on each iteration.

[Damein]

Yeah, I actually thought of that after I typed it out and posted... I should really stop doing that, I write it out and then it comes to me how I should do it.

Thanks for the quick reply though

[guinness]

OK.

[BrewManNH]

What's wrong with this?

For $i = 1 To 24
    _ExcelWriteCell($oExcel, $InitialVolts[$i][1], 7 + $I, 2) ; Write Customer
Next

The first time through the number starts at 8 and goes up by one each time it runs through the loop.

Or even like this for the anti-magic-number crowd

$Count = 7
For $i = 1 To 24
    _ExcelWriteCell($oExcel, $InitialVolts[$i][1], $Count + $I, 2) ; Write Customer
Next

Either way, you're using the loop counter as the number to be added to the initial number, without an unneeded increment statement.