VBA Do While Loop with multiple conditions

Hi everyone,

I'm having some problems getting a simple Do While loop to run. Essentially I'm trying to get it to run as long as one of two conditions is met, so I used an Or function in the loop condition.

This then produces the "Run time error 1004: Application defined or Object defined error" error on that line.

I'm certain my syntax for the two conditions is correct (one is a simple check value in a cell, the other is check the value of a VBA variable) so it would appear the error is caused by the inclusion of the Or function.

So I guess my question is this, have I done something wrong? If so what and if possible why is what I did wrong (I like to understand these things)? Is this something that has to be done in a different way or even is it something that cannot be done?

I'm using excel 2003 on XP SP3

Thanks in advance for any responses.

Cheers,

Matt

@ kedar

I changed it from a Do While loop to a Do Until loop

So for you it would be:

Please Login or Register  to view this content.

This will stop you on the cell containing the values specified