select case problems

[Jesper Fjølner]

I wan't to do evaluate a number with < and > - is this possible?
Or do I have to nest a If-then in there somewhere?

Select Case AgeGroup
Case Is < 39
AgeGroup= 1
Case Is > 39 AND <50 'fails here - how is this done?
AgeGroup= 2
Case Is > 49
AgeGroup= 3
End Select

 

[MikeB]

Select Case agegroup
Case Is < 39
agegroup = 1
Case 39 To 50
agegroup = 2
Case Is > 50
agegroup = 3
End Select

 

[Jesper Fjølner]

Select Case agegroup

Case Is < 39
agegroup = 1
Case 39 To 50
agegroup = 2
Case Is > 50
agegroup = 3
End Select

Thanks!