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)