Can anyone tell me how to speed up this array?

**Ppessina** · 05-13-2014, 05:42 PM

I am dealing with roughly 17000 rows and 30 columns. I am relatively new to using arrays and despite all my research I dont feel like I have a firm enough grasp of them to tell whether the arrays in the code below are any good. the entire process takes about 45 seconds. I think it is getting hung up when I am reading back and forth with the sumif function. I know the code is long and probably does not make much sense without the workbook but I am really just looking for someone to tell me if there is something different I could do with the arrays that would be better. Thanks for the help.

Please Login or Register  to view this content.

**Norie** · 05-13-2014, 05:58 PM

Are you sure it's the arrays that are slowing things down?

There is quite a lot of code before the part that handles the arrays is reached.

**Ppessina** · 05-13-2014, 06:02 PM

The other parts are just designating columns to be referred to. I just ran that part with the arrays commented out and it came in at .40 seconds. Sometimes the code seems to fall out somewhere and my columns do not get populated. I am getting a run time error 7 out of memory and my array will not get pasted. I dont understand why this is.