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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment