Writing multiple for loops together

[tarannam]

Hi, I am writing a program in excel VBA where I want to write two for loops together. For example,
For x = 1 to 10 and For y = 1 to 10
do something ...
Next

But if I write "and" between two for statements the program shows error. If I put : between the for statements or write them separately in different lines then the program works in a different way which I don't want. What I want is for x =1, y should also be 1, for x =2, y should be 2 and so on. How can I do that? Please help. Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
I don't understand what you are asking.
If you need y to equal x then can't you just use one loop?

 

[tarannam]

Thanks.
Alright, I am asking my question again. I want to write a program like
For x = 1 to 10 and for y = 1 to 10
a = x*5 + y *3
Next
But if I write and between two for statements the program throws error.
Now if I write something like
For x = 1 to 10
For y = 1 to 10

 

[tarannam]

Sorry the question got posted halfway.

Ok, I am continuing the question ...

If I write two for statements separately then what the program does is for x = 1 it will go from 1 to 10 for y and again it will do the same for x =2 which I don't want. I hope it is clear now.

 

[Fluff]

If you want x and y to be the same why not just use

For x = 1 To 10
   A = x * 5 + x * 5
Next x

 

[tarannam]

No the original problem is a bit different. I was asking the question in a simplified form. Actually I was using array where array index for two variables are same but the values itself are not the same.
....
For x = LBound(a) To UBound(a) and For y = LBound(b) To UBound(b)
c(z) = Exp(b/5)*(Exp(b + a)
Next

Here I want when index of a is 1, b should also be 1. The full program is a long one, I am showing here the part where I have problem.

 

[Fluff]

As long as the arrays are the same size & the Lbound is the same for both just use

For x = LBound(A) To UBound(A)
c(z) = Exp(b(x)/5)*(Exp(b(x) + a(x))
Next

 

[tarannam]

Got it. Thanks. But just to know isn't there anything in for loop like "for x = a to c and y = d to g" as we can write in case of if statement "if a = b and c = d"?

 

[Fluff]

No, you cannot do something like

For x=1 to 10 and y = 1 to 10

 

[mikerickson]

You might be looking for sytnax like

For x = 1 to 10
    For y = 1 to 10
        ' do something
    Next y
Next x