I don't understand your first question, but your second can be solved like this:

where i is a looping variable, which you can use in calculating var1. c1 and c2 are constants and var1 is a variable.Code:For i = c1 To c2 Step 2 var1 += .... var1 -= .... Next i

Hope this helped.