Help With Indefinite Loop

[jadown]

I have a For loop that does exactly what I need it to do. However, I think in the future the number of cells(account numbers) will increase/decrease. I will like for the code to loop until the cell in row 1 = 0 or has the word total in it. Here is my current code.

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[6StringJazzer]

patel45, this is the right idea but there is an error in the logic, plus it does not compile. Using "Or" here means that no matter what value is in the cell, it will either be not 0 or not "total", therefore creating an infinite loop. You need to use And here. Also a parenthesis is missing so it doesn't compile. I suggest that at a minimum you compile code before posting (sometimes is it not possible or practical to test it).

Note my change in red:

Please Login or Register  to view this content.