The turn off multi-thread for formulas bit increases my VBA speed by more than 10-fold... it's so counter intuitive! I can't believe it has taken me ten years to figure this out after wondering why each new computer ran slower than the previous.