Hi Todd
dou you need a VBA solution or would a worksheet formula also work for
you?. You may try
=SUMPRODUCT(--(COUNTIF(B1:B1000,A1:A1000)=0),A1:A1000)

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
Hey guys

I have 2 ranges. A:A and B:B. What is the code that will
go through range A:A and if it finds a value that is NOT
in range B:B, it will add it. If a value in range A:A is
found, then do nothing.


Todd