I am running a macro that takes a really long time to run because there are so many iterations that need to be tested. The results of each iteration are independent but will be summarized at the end with a graph or table. For simplicity's sake, let's say the code goes something like this:
dim testValue(1000*1000*1000) as integer
for i = 1 to 1000
for j = 1 to 1000
for k = 1 to 1000
testValue(i + 1000*j + 1000*1000*k) = i + j + k
next k
next j
next i
Call scatterPlot(testValue)
Is there a way to do these calculations in parallel? I don't know much about parallel processing but I have been reading about asynchronous UDF's for Excel 2010. I just can't find any examples that are in layman's terms.
Bookmarks