Condition

[Sasa]

Hello, I was wondering, in VBA, is there a possibility to
set condition with amount of numbers?

For example to look like this:

Dim i as Long

If i = "numbers from 1 to 100" then ...
Else
....
End if

Thanks in advance.

Sasa

 

[Jezebel]

Select case i
Case 1 to 100
....
case else
...
end select

 

[Sasa]

Thanks.

Cheers.