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?
Comments
Post a Comment