Optimizing VBA: Multithreading a Range Calculation

[Telefonica]

I have a very large range of formulas that spans E6:YO6052.

Each cell in the range performs a few simple calculations (some multiplication and addition). There are no dependents inside the range (i.e. all the formulas reference cells outside the range and these cells are not dependent on any values inside the range).

I'm trying to optimize the calculation of the range. Originally, I used RangeCalculateRowMajorOrder. My reasoning was excel wouldn't look for dependents and references using this method, but I'm wondering if there's a more efficient way of doing it. I'd like to take advantage of excel's multithreading capabilities, but I also don't want excel to check for dependents, etc. (because there are none in my range).

Would xlThreadModeAutomatic and another method of calculation be more efficient?

FYI - I've set calculation mode to manual so I can have full control of when certain cells need to be calculated, and when they can just sit there. I'm using 2007.

Thanks in advance.


Regards,
Adam

 

[Telefonica]

Hmmmm.... I believe my machine has two processors. Maybe, could I split up my range into two sections and have one processor calculate one half with RangeCalculateRowMajorOrder and the other processor hack away at the other half?