View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zsplash zsplash is offline
external usenet poster
 
Posts: 6
Default If ... < or ... < then statement

I think I must not understand the "or" (and <) qualities of code, in an
If-Then statement.



Here's my code:

If MyType < "DIV" Or MyType < "UNM" Or MyType < "MOD" Then
blah, blah, blah

End If



When MyType = "DIV", the code progresses to the [blah, blah, blah]. My
little brain is trying to think that if MyType = "DIV", the code should
bypass the [blah, blah, blah].



Please enlighten me.



TIA