Calling out inequality with ElseIf

[cmeier7]

I want to call out an inequality with an If Statement. I want r to be between 50 and 100. I have something like this in the first line of an ElseIf:

 ElseIf r > 100 < 149 Then

Of course this is not right- how do I write this so that VBA will match r with a specific range, in this case between 50 and 100. I have used nested Ifs also with no result.

Thanks,
-cmeier7

 

[kpark91]

If r >= 50 And r <=100 Then