Take a look at this page:

http://www.cpearson.com/Excel/Duplicates.aspx
and this page
http://www.cpearson.com/excel/NoDupEntry.aspx

--
Regards,
Tom Ogilvy


"Mekinnik" wrote:

As I enter in company names into column B in my worksheet I would like a
macro to automaticlly check to see if I have a duplicate name already entered
and if so show it in a pop-up windows as an error. Now I thought a Loop If
statement would work however if memory serves me correct I would have to
enter all the names in my statement. Any assistance would be appreciated.
Thanks