Preventing Duplicates using VBA (code)

[Jerry McCutchen]

I have a sheet that has 8 digit (111-1111) telephone
numbers in colume B. I need to programatically prevent
anyone from entering duplicate values. I can do it using
the Data - Valadation and the COUNTIF function, but that
leaves the validation runction open so others can change
or delete it. I really would rather do it in VBA.

Help.

Thanks to all...
Jerry McCutchen

 

[Jerry McCutchen]

Tony,

Thank you so much! This works as advertised!

Jerry