>Between is fine if you actually want a range, but if you want to match the exact values the you want Inlist instead.
>

If InList(n, 1, 2, 3) Then
>   ...
>EndIf

>In the case of the example, the one you'd choose would depend on whether you are happy matching a range, in which case in Between, or an exact list of values, in which case you'd use InList.
>
>Ian Simcock.


Using inlist() also can have documentation side-effects, as you are explicitly listing an array of values which are expected, indicating solid integers, for example, and only of the ones listed. Using between() is a little more ambiguous.