Compare rows in VBA

[Misca]

How do I compare entire rows with each other?

I'm trying to write a macro that finds duplicate rows in CurrentRegion and deletes the duplicates but I'm lost with the code:

The CurrentRegion has headers and is sorted so the duplicates (if any) should be right ontop of eachother.

The problem is that there's 30 columns in each row and comparing cells one by one for each row is going to take a lot of time (there can be up to 65000 rows in the CurrentRegion).

What would be the best (=fastest?) way to do this?

 

[Domski]

Hi,

I'd probably use advanced filter to create a de-duplicated version of the data on another worksheet.

Dom

 

[Misca]

Unfortunately this is hard / impossible to do: The macro is going to update a larger database workbook in customer's location and I can't be sure what info has already been updated to this database.

 

[Domski]

Unfortunately this is hard / impossible to do: The macro is going to update a larger database workbook in customer's location and I can't be sure what info has already been updated to this database.

Not quite sure what you mean. The code for doing the advanced filter is pretty straightforward and can mostly be obtained by using the macro recorder.

Dom