Case is statement with And

[neveu]

hello,

i would need to create a Case is Statement where the criteria is complex, meaning i would have to use the AND.

how should it be written to work?

i would need something like

Select Case valuetocompare
case is <=3 AND case is >1

but if i write it like that i get an error.

any help is greatly appreciated

 

[ScottR]

Select Case can be much easier to read in a lot of circumstances. On the other hand, IF...End If is, allegedly, more efficient.

But how difficult could an If..End If possibly be to read when it could be replicated with a Select Case?

 

[RoryA]

Which is easier to you:

   If (x >= 1 And x <= 10) Or x = 15 Or (x >= 20 And x <= 30) Or x = 46 Then

or:

Case 1 To 10, 15, 20 To 30, 46

 

[ScottR]

The select statement, however I'd also say they are both trivially easy to read.

 

[RoryA]

True, but with more branches of the code, the If will become correspondingly harder, especially if using longer variable names than x.
We are getting somewhat OT though.