Help in finding if a variable match a list of strings

[Chrispelletier]

Hello,

Looking for some help on checking if a variable match a list in an array. As an example, the variable will be updated during the macro 5 times and will be one of the following:
Region1, Region2, Region3, Region4, Region5

What I am looking for is if it is region1 to 3, then goto step1. If not, go to step2.

Below are some examples of codes I tried but did not work, I believe I am close to the solution but could not find a solution online after searching a bit.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks you for your time!

[Mumps1]

You have to loop through the array:

Please Login or Register  to view this content.

[Rick Rothstein]

Does this work for you...

Please Login or Register  to view this content.

[Chrispelletier]

Thank you that worked, will mark as solved.