Hi Howard,

Am Sun, 2 Aug 2015 06:11:10 -0700 (PDT) schrieb L. Howard:

I don't know the actual formulas used in C, I was using =A1 in a cell and in another cell =A2. Then I was giving A1 and A2 the same value to produce a duplicate value in C.

Would that be sufficient to fire a calculate event if the code was written correctly?

if a value in column A fires the calculation you could create a data
validation for column A = Custom = =COUNTIF(A:A,A1)=1
Then no duplicates can be entered in A.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional