delete the entire row if duplicate found in column

[gujugolf]

Is there a way I can delete the entire row, if a duplicate is found in column A via vba?

[thelisa]

Below is an example with a header.

Please Login or Register  to view this content.

If you do not have a header, xlNo.

You can also record a macro and see the code. Click on the developer tab, record macro, select the column, then hit "remove duplicates" and then see the code.

*edit: sorry i misread your post. i do not know how to delete my post. my apologies

[Darzou]

Hi,

Please Login or Register  to view this content.

Regards,

Darzou