Easy VBA Loop Through Variables Looking for Boolean Flag

[barrymoe]

Hi All,

I'm attempting to write a code that looks through a potential of 50 different Boolean variables and creates a new variable "YES" if at least one is flagged yes.

I am extremely new to VBA and just know basic loops. Any help would be appreciated.

Thank!

 

[theBardd]

No loop needed, simple but long OR test

    bNew = b1 Or b2 Or b3 Or … b40 Or b50

 

[DanteAmor]

You have the variables referenced in cells or how you fill the variables.
It can also be:

vYes = a = b = c = etc