What if the counter that counts the number of "Registered" to put into column H also checks if the product allready have been "Registered".

So that those product with "Registered" in column H do not count when displaying the msgbox. I tried to change the code a bit but not succsessfully.