hi

i have quite a few case statements to write, I know its possible to do it with a loop but the point of the excercise is for me to learn CASE....

there is an array of variables, "varsquare" that goes from 0 to 8, thats 9 elements. Each element can take the values "human" or "computer" or ""

I wish to create a set of case statements that


Select Case varsquare
Case varsquare(0) = "human" and Case varsquare(1) = "human" and Case varsquare(2) = "" then do this

Case varsquare(3) = "human" and Case varsquare(4) = "human" and Case varsquare(5) = "" then do this

etc

Case Else then do this

End Select



Anyone know how it is possible to use an array in a case statement?

cheers

dgr