Parallel Processing

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:

Please Login or Register  to view this content.

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.

Yes, it does not seem to apply exactly to what I am trying to do. Do you have any other ideas for implementing parallel processing in VBA or another technique for cutting the time down on this calculation? I don't think I am using anywhere near my computer's full capabilities and it is taking forever.

You can open X instances of excel to the amount of cores in your pc. Set each excel instance to a different core. Then run a set range on each one. Once they are all finished copy them back into 1 sheet and do what you need.

Consider posting the original code. There might be a more efficient way to handle your calculation that doesn't involve nested loops.

Is there a way to do that programmaticaly?