How do I check for duplicates in a one-dimension array? I need to then return this value via a MessageBox to the User. I do NOT want to delete the row, only find it and let the user know there is a duplicate that needs to be corrected. This is to bedone in VBA. So, if my range name is "RangeName", then what? I have looked at some of the examples, but they delete the row and that is not what I want.