Well, you're in over my head, too! 8\ I've not tried anything like that,
but I think if I were going to try it, I might do something like the
following:
Enter a row of data.
Use a MATCH formula to see if the data entered in the first column
exists in the column above it.
If Yes, grab the row number. Offset one cell in the new data row and in
the MATCHed row. Compare values; if equal, Offset and compare again until
the values don't match or the end of the data in that row is reached. If
all Yes, MsgBox "Houston, we have problems!" If not, rinse and repeat.

Then again, rather than do this dynamically as you enter a new row of data,
would it be possible and easier to enter all your data first, and then check
things?

Sorry, you've gotten all I've got! Wish I knew more and could help more.
The other thing I would recommend is Ron DeBruin's Google NG search add-in
(http://www.rondebruin.nl/Google.htm). You can find all the times other
people have asked similar questions.

Ed

"jEREMY" wrote in message
...
Hi Ed, Thanks for this but I can't see that it will solve my problem.
Under preventing Duplicate sit says that this will not work on data entered
via VBA. Also the data in the cells could be duplicated in individual
columns, it is the combination of the data in all the cells in the row that
I need to check for duplication against rows above the new entry