There are tons of examples of this in the community forum. Put this in your
favorites:
http://www.microsoft.com/office/comm...4-91038e3eb1e9
then you can search for Excel delete duplicate rows and spend all day
looking at the many samples posted.


"MarkM" <mark_mattson(at)yahoo.com wrote in message
...
Does anyone have some basic code that will check for and delete duplicate
rows?

I have a list of items number, which is sorted, coming form a customer
sales
history file and need to remove the rows with duplicate rows. The item
numbers in column C.

Thanks for you help.