Do until with multiple conditions

[Stefan22]

Hi,

I'm new to VBA so sorry if this is too basic.
I'm looking for an easier way to write multiple "and" operators
after "Do until" statement. Since I have over 20 conditions, I would like
to avoid writing them one by one.
So, how do I replace:

Please Login or Register  to view this content.

with something less cumbersome.

[Mad-Mizer]

Hi Stefan, in my experience, coding individual conditions can be a cumbersome ordeal and part of the reason why coding can get quite bloated. Coding is also very precise and while variables can be made to hold different values and etc., conditions are very rigid by nature.

So what can you do? Most likely, you'll have to code each condition but without seeing what any conditions are, I can't help you. If you know all your conditions, and you should, provide 4 or 5 here so that someone can get you started.

[Stefan22]

Thanks for the advice Mad-Mizer.

Here's the simplified version of my code:

Please Login or Register  to view this content.

There must be a way to get rid of these ANDs, right?
Although the code is working, it is extremely slow (takes more than five minutes to execute).
And I thought it might run slightly faster if I could deal with those conditions in a more efficient way.