I'm fairly new to VBA, and I can't find an easy way to test if any of the specified variables equal a specified value. The below seems to work, but is there an easier way to do it?
If variable1 = 1 Or variable2 = 1 Or variable3 = 1 Or variable4 = 1 Or variable5 = 1 Then End If
I've also tried the following, with no luck.
If (variable1 Or variable2 Or variable3 Or variable4 Or variable5) = 1 Then End If