Local for loop variable and other basic questions

[epslugger]

Hi,

I'm coding in excel 2010 and I was wondering if there is a way to create a variable that is local to a for loop. The equivalent code in c++ would be:

for(int i=0; i<10; i++).

I have tried the following and I get the error "Compile Error Expected: ="

For i as Integer = 0 To 10 Step 1
Next i

Thanks

 

[Norie]

You can't do that in VBA.

Just out of curiousity why would you want to?

 

[epslugger]

Currently I have many for loops with variable like i1, i2, i3, i4, i5, j1, j2, j3.... If i could make them local to the for loop they are used in, then I could just have i and j be used over an over again. This would eliminate many lines of my code devoted to declaring these variables.

 

[Norie]

You can use i and j over and over again, you don't need to use a different variable for each loop.