I assume you can write the macro but are just looking for an efficient way to find duplicates in a row in Excel. It is tricky but I've had to do it before and what I do is look at how many unique values are in the row and if the number of uniques are less than the number of columns then I know there are duplicates in the row. Here is the formula I use when none of the cells are blank or contain text...
For your example if you start your values in A1 then put that in C1 and copy C1 then paste it in C2 and C3 and you will see that it shows 2 for rows 1 and 3 and 1 for row 2 because it only has one unique and therefore since 1 is less than the number of columns (2) you would delete it.
Here's a screenshot of using it with 6 columns. Any column where the formula results in a number less than 6 has duplicates in the row and you would code it to be deleted in your macro.
G1 would contain the formula =SUM(IF(FREQUENCY(A1:F1,A1:F1)>0,1))
copy G1 and paste it into G2 thru G5 ...
Edited by NeverSayDie, 08 April 2012 - 08:56 PM.