Sub fastcalc()
  'disable screen updating:
  Application.ScreenUpdating = False
  For i = 1 To 100
    Selection.Calculate 'recalculate only the selected range
  Next i
  'enable screen updating:
  Application.ScreenUpdating = True
End Sub
March 9, 2010
Faster iterative calculation of a worksheet with circular references
Subscribe to:
Posts (Atom)