Hi Dave,

Strange that this did not work for you, i did notice that i had the order for the range selections back to front but thought it wouldnt have much of an effect as it prompts the user as to which range to select in the range input box.

I like to keep my examples on this forum as clear as possible so i tend to avoid all of the error handling so as to keep the code readable and easy to follow.

I will include the file i used to test.

Find_Multiple_Values.xlsm