Finding Identical Values in Two Columns

Hello,


This time, I have to write a sub that checks if a value is duplicate in two columns. If it is, a message box should appear saying "blah." If it is not, a message box should appear saying "okay."


I have written a code. However, when I run it, I always get the message box saying "okay." This should not happen because there are definitely identical values in the two columns. Any help fixing my code would be great.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

You are comparing every cell in the A range to every cell in the B range and then giving a message for every comparison. You are showing 100 messages. What your code is doing is not what you described that you want it to do.

If you want to check each value in the A range, and give blah if it has a dupe in B and okay if not, then do this. This will give you just 10 messages, one for every value in the A range. I also expanded your message a bit:

Please Login or Register  to view this content.

Hi there,

Here's one way:

Please Login or Register  to view this content.

Please use code tags when posting code as I have done. Thank you.

Robert