For inside another For, when condition reached in "For inside" make "For outside" exit

Greetings, im very noob so please be gentle.

I have this:

For i = 1 To 200

.
.
.

atuais = Sheets("Geral").Range("$L$12:$L$32").Value
velhos = Sheets("Geral").Range("$H$12:$H$32").Value

'Compare 2 columns (value by value)

For j = LBound(atuais) To UBound(velhos)

If ((atuais(j, 1) > velhos(j, 1)) And (atuais(j, 1) - velhos(j, 1) < 0.01)) Or ((atuais(j, 1) < velhos(j, 1)) And (velhos(j, 1) - atuais(j, 1) < 0.01)) Or
(atuais(j, 1) = velhos(j, 1)) Then Exit For

Next j

Next i

What I would like to happen is:
-It verifies the "If condition" for all the values on the rows of "atuais" and "velhos"
-If the condition is verified, all the values are almost the same (error of 0.01) or equal to each other, exits the "For i", right now it only exits de "For j".

Cheers

You have 2 For Loops. For #1 is "j", For #2 is "i". "Exit For" affects the first For loop it sees.

You need a 2nd if statement to check if "J" finished early and exit "I" if it does.

Please Login or Register  to view this content.

Also
ABS() = Absolute Value, so you don need to worry about negatives.

This makes it shorter and easier to read.

Please Login or Register  to view this content.

I've done this:

'Put between Next j and Next i
if J <> ubound(velhos) then exit for

but it doesnt do any loop in the "For i", it exits the "For i" in i=1.
Thanks for the abs tip

??? I think i am missing something from your code because:

Please Login or Register  to view this content.

Will exit once J finds a match. I don't know what your "I" is checking since that loop only looks at "J".

Does Solver have a random number generator? Because your "I" for 1 to 10 will run the same calculation 10 times.

I want it to be moreless I=1 To 200, i was only testing so it wont take that long, as it doesnt stop . I dont understand ur question, but it's not random. It's to do the same calculation every time, but with different values, it does one time with some values i give, then the solver give me other same amount of values, and those i put as new values for calculation and solver give another values i put again for solver... etc.. etc.. 200 times, or the times when the values i insert (copy/paste) are equal to the values solver give... just that!

How are you changing the value when it goes from 1 to 2, then 2 to 3? because for i = 1 to 10 it does not stop. And each time it uses the same answers.

If you try to run the macro with I=1 To 10 and without (If J <> UBound(velhos) Then Exit For), you'll see in sheet "Geral" for example the first value of the column "Velhos" is very similar to "Atuais". After some more iterations it's going to become the same value, and that's when i want it to stop. Maybe this part of the code is not doing what i pretend, comparing those values:

For j = LBound(atuais) To UBound(velhos)

If (Abs(atuais(j, 1) - velhos(j, 1)) < 0.01) Or (atuais(j, 1) = velhos(j, 1)) Then Exit For

Next j

I use copy - paste or pastespecial.