Looping with fixed values

[Miguel Coego]

Good evening,

My question is related to loops.

I need to create a subroutine looping with fixed values.

That is, x would be, instead of a logical sequence (1, 2,
3, etc.) to which a could assign a mathematical formula,
an interval of values like (E012, E031, E130, etc.)

Could somebody help me with this? It is very important for
my job and I'm completely lost.

Thanks very much indeed.

 

[Kim Mitchell]

Do
Select Case x
Case "E012","E031","E130"
Exit Do
End Select
' Other code here.
Loop

Hope this helps

Kim

 

[Miguel Coego]

Thanks very much Kim!!!!!!!!!,

I´ll try with it.

-----Original Message-----
Do
Select Case x
Case "E012","E031","E130"
Exit Do
End Select
' Other code here.
Loop

Hope this helps

Kim





.