I have a macro that executes many calculations and then attempts to write out the data which is stored in column arrays to a worksheet. The calculations happen fairly quickly but when I try to write out the arrays to a worksheet it takes HOURS!
I have attached an example workbook to show what I am doing but unfortunetley this example runs fairly quickly, unlike my full macro with all the calculations. The array size in my full macro is 86000, where it's only 2000 in this example. I had to reduce the array size in this example in order to reduce the file size so that I could upload. Even with array size of 86000 in this example workbook the macro runs quickly.
I know its not the calculations in my full macro that causes the long run time because when I comment out the For Loops used to write out the data the macro runs quickly.
I'm hoping to get some ideas of what could be going on because hours of execution time is unacceptable. Any help would be much appreciated.
Thanks in advance.
Bookmarks