I need to do something similar to a mathematical summation. The code works fine, but its slow.
I've tried some of the VBA Speeding up tips but they don't seem to help on this macro.
Having 1000 rows takes about 16 sec, however having 2000 rows takes about 65 sec (4x the time), 3000 rows 148s (9x), and so on. I need to do it with almost 250.000 rows, and with the current code that would take almost 12 days.
Any idea how to make this faster? Thanks!
Here is the code