While loop question

[rick051112]

Here is my code:

Sub number()
Dim x as Integer
Do While Cells(x,3) <> 4 Or Cells(x,3).Cells.Offset(0,1) <> 4

x= x + 1
Loop
End Sub

My data is as follow:
C2= 3 D2= 4
C3= 4 C3= 3
C4= 4 D4 = 4


This is a simple example, but I am wondering why "Or" works in the while loop instead of using "And"? Basically the Or statement will take the while loop to the last row, but the And statement stops at the first row.

Thanks!!

 

[Joe4]

Welcome to the Board!

Please explain, in plain English, how you want this to work.
What is the logic?
What should this be doing?

Also, for this part:

Cells(x,3).Cells.Offset(0,1)

why not just use this?

Cells(x,4)

 

[Micron]

In the context of just addressing the why of it, here's your first iteration with the first row of values:
Do While 3 <> 4 AND 4 <> 4 is obviously not True so the loop is over.
Do While 3 <> 4 OR 4 <> 4: one of them is True so the loop continues. OR means Do While this OR that. As long as one of the This or That is True, it will loop.

Logical operators can sometimes be a bit confusing, especially when 2 or more are used in the same evaluation. They often need to be grouped so that the AND and the OR are evaluated in the correct order for the logical tests.

 

[rick051112]

Welcome to the Board!

Please explain, in plain English, how you want this to work.
What is the logic?
What should this be doing?

Also, for this part:

Cells(x,3).Cells.Offset(0,1)

why not just use this?

Cells(x,4)

Ty for your reply! I am new to vba.

Basically it should continue to loop through the row if the conditions are not met in columns C and D.

So if cell C2= 3 and cell D2 = 4, it will keep on looping until it finds a row where the value in column C = 4 and the value in column D = 4.

My question is that it seems to work with the "Or" statement in the while loop and not the "And" statement. But this seems to be backwards. Why is that?

 

[Joe4]

My question is that it seems to work with the "Or" statement in the while loop and not the "And" statement. But this seems to be backwards. Why is that?

Its not, if you break it down and think about.

Basically, you want it to stop when BOTH columns C and D are 4, right?
So, you basically you want it to keep running if at least one of the values in C or D is NOT 4. That is an OR statement (since you are checking for NOT equal to 4).

If you use AND, you tell it to keep running only when BOTH C and D are NOT 4 (not either one).
So if either one is 4, it will stop.
Since column D is 4 in your first example, that is where it would stop.