Delete Dupes Macro - Error When No Dupes

[JADownie]

Hi -

I have the below macro that I have been using, and it works perfect to flag and remove duplicates. But when there are no duplicates found on the sheet, I get an error at the line below in red.

I am not sure how I would revise this to account for a scenario when there are no duplicates to remove, and I was hoping that someone might be able to assist me here today.

Thank You SO much in advance!!

Please Login or Register  to view this content.

[nathansav]

Please Login or Register  to view this content.

needs to be in an if statement, so if ubound(toDel)>0 youre not finding anything, then trying to delete something.


not tested.

[JBeaucaire]

When deleting a lot of rows from a sheet, I prefer not to delete them individually in a loop. I record the duplicates into a range, then delete the entire noted range all at once at the end. This is the basic approach I use, tweak as needed:

Please Login or Register  to view this content.

This macro leaves the first instance of each item found and will delete any found below that first instance.

[JBeaucaire]

Also, I would be remiss for not pointing to the Data > RemoveDuplicates feature available in all the recent versions of Excel. No VBA needed. It can also be triggered with VBA.