Looping Through Variable Names

[Coach3131]

I would like to loop through variable names to find a result of an array variable.

Lets say I have an array value = "TestResult"

There are 15 variables that may match that result
Variable01, Variable02, Variable03, etc. How would I write a loop to check the variable result

For y = 1 to 15
If Variable & y = "TestResult"
Then
<Do Code Here>
Else
Next y

The other problem is that there is a two digit number 01, 02, 03, etc.

 

[Coach3131]

Just bringing this back up again since it was buried.

 

[shg]

You can't loop through through variables like that. You could instead use an array of variables, and loop through the array.

EDIT: For completeness, you could also use a for each loop:

for each v in array(var1, var2, ..., var 20)
    if v = "Test Result" then
        '...

... but it doesn't give you the variable.