How to control of repeating procedures? (delete duplicates rows)

I would like to create a structure for repeated operations by using Do While Loop. The DElDuplicates, which searches for and deletes duplicates rows in a database is a good example to explain the situation. Having sorted the database on a specific 'code' field, the entries in the code column are processed row-by row. If the values of the currentCell and nextCell are the same, the currentCell row is deleted.

I think my problem is caused by the reference objects. I don't know how to name it in my worksheet.

Please Login or Register  to view this content.

Capture.PNG

Not sure if this helps

Please Login or Register  to view this content.

You need to create Named Ranges as described at the beginning of the routine otherwise the code does not know what to sort, or on what basis.

See the updated example.

You're welcome. Thanks for the rep.