Hello, I have a problem. In excel macro I have to use a "do
while loop". I have two conditions to pass the loop. I made a code as
below,

d1=2
d2=5
r1=0,
Do While and(r1 =0, d1 < d2)
.....
.....
.....
loop


but it gives an syntax error message at the "do while" line.
I guess I am using "and function" improperly. Thanks.