Search cells in column for any of three possible values?

[hadamhiram]

I apologize in advance for having no VBA knowledge or skills!

Basically, I want to check/search the cells in a column one by one, and keep checking/searching until a match of any of three possible values is found.

I know (sort of) how to do this for just one value, but I don't know how to do it for three possible values!

I thought of using a do-until loop that runs as long as the current cell's value is not equal to the three possible values, but I wasn't able to get that to work...

Any other suggestions?

Thanks for your help!

[:) Sixthsense :)]

Share your current code

Also the criteria's to match

[hadamhiram]

Well, the code I had that doesn't work is this:

Do While (matchValid <> "Building") Or (matchValid <> "Integrating") Or (matchValid <> "Total")
For matchCounter = 1 To 10
Set matchValid = matchValid.Offset(1, 0)
Next matchCounter
Loop


Thanks!

[:) Sixthsense :)]

I don't know what is the use of For Loop?

Since you have not used matchCounter inside the For Loop

[hadamhiram]

I just copied some code I found online that I guessed might work, but it doesn't I'm not sure what the best approach to the problem is. Maybe it isn't a do-while loop at all, I really don't know. Again, what I want to do is check/search the cells in a column one by one, and keep checking/searching until a match of any of three possible values is found. Any suggestions?

[:) Sixthsense :)]

Check whether this helps you

Please Login or Register  to view this content.

[hadamhiram]

I will try it now - thanks!