Looping a FindNext Until All Values Found

[morbdetro]

I have a macro that takes a value in column A and searches column B for that value and highlights it green. If the value does not exist it moves down to the next cell and loops until no values are left in column A. This works but I was hoping to improve on it. Sometimes a value is listed multiple times in column B. I was able to write a loop for it to find all values in column B but I was never able to figure out how to terminate the loop when it found all values in column B.

The code listed below does not contain that loop, but I was hoping somebody would be able to help me out with writing the loop and having it terminate.

Please Login or Register  to view this content.

[morbdetro]

Actually never mind. I just realized I do not need to duplicates in Column B so I will just start the macro with removing duplicates from Column B.