Never mind, found an answer from a previous post that has been very helpful:

"You may want to look at Chip Pearson's site. He has lots of techniques to
work
with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx"


"Jesse" wrote:

I want to write a macro that will find if I have entered a duplicate entry on
a worksheet. Any suggestions?