Hi.
How to delete rows in a specific range by VBA
I.e
I want to delete duplicate rows in a table D10:K20.
Remove duplicates within a defined range
-
-
-
Re: Delete duplicate rows
Hi Redahussien,
The following code will remove duplicates in all cells in that range. If your data doesn't have headers simply change "xlYes" to "xlNo"
Edit: do you mean only if the whole row is identical? If so then quickest way to do that is with a helper column or two.
-
Re: Remove duplicates within a defined range
Thank you.
I mean duplicate rows.
If two rows are exactly identical delete one of them -
Re: Remove duplicates within a defined range
Cross-Post
http://www.vbaexpress.com/foru…386-Delete-duplicate-rowsand here
http://chandoo.org/forum/threa…ete-duplicate-rows.31637/ -
Re: Remove duplicates within a defined range
MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
*
-
-
Re: Remove duplicates within a defined range
With all respect
How to add link to that post. -
Re: Remove duplicates within a defined range
Click the "edit" button below the first post and then add the links please
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!