Hello all:

I have a userform that allows a user to enter data from columns A to P. I successfully installed a macro (which I got from this site:http://www.exceltip.com/st/Preventin..._Data/886.html)

that deny a duplicate entry in Column A. The macro then "clears" the duplicate value in column A, which is okey. However, I need help for a code so that the
rest of the entries from Column B to P (within the same row) will also be cleared automatically. I tweaked the "target.value" quite unsuccessfully.

Thanks for the usual help.

WK