Do Loop Until problem (Won't Stop)
Posted on 2004-04-28
I have a problem
My loop won't stoppp
Dim startTime As Date
Dim endTime As Date
startTime = "9:30:00"
endTime = "18:00:00"
startTime = startTime + "0:10:00"
Loop Until (startTime = endTime)
It won't stop?
minute2 = DatePart("n", startTime)
If minute2 = 20 Or 50 Then
The above works if the if statement is only looking for 20 . After I put the Or in it it just keep staying on the top and won't go to else.
Any idea why?