Shorter means of looping

[silkpantsman]

Hi,

The code below does what i need it to but i get the feeling that it is more code than is necessary. I would prefer to be able to just use one for loop for all my if statements but when i run that code i get a compile error : next without for. Any suggestions would be great

Thanks,
SPM

Please Login or Register  to view this content.

[zbor]

Try

Please Login or Register  to view this content.

[silkpantsman]

Thanks zbor

[zbor]

Or Case statement for more criteria

[silkpantsman]

Cool i dont know CASE at all, will check it out.