Macro to find cell based on one of three different values.

[Alphonse68]

Hello everyone.
I'm trying to write a macro that will go to a cell in a specific column based on one of three values.
I have a column (L) with a formula in each cell, starting on L3, which compares values of six cells, in pairs on the same row.
The number of rows changes from time to time, growing or shrinking.

=IF(E402=M402,IF(F402=N402,IF(G402=O402,"","W"),"H"),"M")

The macro I want should find any one of these three values, W, H, or M, and go to that cell, regardless of which it finds first.
Basically, I want it to go to the next "error", since these values reflect differences in the comparisons.

I tried the following code, but it only works for one of the criteria; I don't want to write three separate macros
and I don't know how to make an "or" statement... "find W or H or M and go there"

Please Login or Register  to view this content.

Thank you, in advance, for any and all help, ideas, suggestions, etc. provided.

Cheers,
Alphonse

Moderators note: code tags added for you - this time

[FDibbins]

Hi and welcome to the forum

Please take a(nother?) look at rule 3 concerning code tags

[fredlo2010]

See if this helps

Please Login or Register  to view this content.

Thanks

[Alphonse68]

Hi Fred, thanks for answering. I tried your code, but it just goes round and round. In the meantime, (gotta love bosses just about now) a couple of changes were made to the spreadsheet, but the only thing that got affected for my purpose is that now the column became "I" instead of "L". My questions: Should it now look like this, changing the 3 L's to I's in the For statement? Does it pop out of the loop (ignore the Next statement) once it finds a match?

Please Login or Register  to view this content.

Note to moderator: Thanks for the code tags, and I hope I did them correctly... :-/
Cheers

[fredlo2010]

Hello,

I totally forgot the exit when a value is found.

Here is the final

Please Login or Register  to view this content.

Thanks

[Alphonse68]

Sir, I need to thank you. Works like a charm. Now, regarless of how many mistakes any one line has, it goes right back to it to point out the next. No more scrolling looking for the next instance. Thank you so very much.
Now, being a noob (overstating the obvious), I imagine that I click on Add Reputation, right?
Take care, and
CHEERS!!!

[fredlo2010]

if you think i helped yes

thanks a lot

[Alphonse68]

Last question: is there a way to make this post show as SOLVED?

Found it. Thanks again!!