ITS VBA again!

I made two misstakes today.

The first one was touching vba, the second one was assuming things.

The two statements are almost the same except the braces. VBA uses IF [condition] THEN..i soo foulhardly assumed that, when you just chain conditions together with an AND its taken as one statement. While in reality it apparently ignores some conditions and not some others.

I really dont bother with VBA a lot and try to avoid it, but upon occassion the need arises. I still dont know why the brace variant does the expected behaviour while the without does not. It seemingly does not ignore thew first two conditions but the third which makes it even more confusing. But as i dont know enough about VBA to say with confidence its on Excel and not on me i squelch my rage and tend the happiness that it now works..somehow.