2023-09-04

How do I check if my variable value is in a pre-defined list of static values in VBA?

How do I check if my variable value is in a pre-defined list of static values in VBA? I am a beginner at this, so please keep it really simple!

My variable is called RowNum and has a particular value I want to see if it appears in a pre-defined static list of values (e.g. 15, 22, 35).

I can only find more complicated examples and I'm getting lost in it all!

Something to do with arrays?



No comments:

Post a Comment