Can someone please help me speed up my macro?

Hi,

I was hoping someone could help with any obvious ways to speed up the below macro?

Essentially, it is an overarching For-Next loop with multiple arrays, looping through arrays and a couple of dictionaries.

I often need to run it for over 100 cycles with 3,000 - 4,000 rows of data. Unfortunately this can take hours, even days to complete.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

I advise you to check often what is more profitable. Whether using a spreadsheet function or a typical VBA solution. Although it is generally said that spreadsheet functions are fast, this is not always the case. Proof below.
There are still a few things to optimize in the code, but I think MOD is your main problem.

Please Login or Register  to view this content.

Artik

There are a few things that can be done to speed up the code, but as @JohnTopley suggested, a sample workbook would be recommended for testing on.