How to speed up deleting duplicates using a filter

Hello guys,

I am working on this code that will take all the ".CSV" files in a directory and import them into a massr workbook. Up to here the code runs perfectly. When I have all the data in the Master workbook I have to make sure I have no duplicates. For that I concatenate the name of the company and the address to obtain an auxiliary column and then filter and eliminate the duplicates the only issue is that it takes forever.

Any ideas on how to speed this up a little.

Thanks

Please Login or Register  to view this content.

Thanks for the reply xladept

I really don't understand what you mean plus Arrays are a huge headache for me. But I tried something simple and it worked instead of creating filters to deduplicate why dont use the function that comes with excel.

Here is my final code

BTW I took it out of the main code for modularization

Please Login or Register  to view this content.