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.