More than 5 years have passed since last update.

再計算と描画のON、OFF切り替え

Last updated at 2012-12-26Posted at 2012-05-11

nyan.vb


Sub foo()
'メインルーチン実行時のパフォーマンス改善に有効'

Application.Calculation = xlManual     '再計算の停止'
Application.Calculation = xlAutomatic '再計算の再開'

Application.ScreenUpdating = True     '描画の再開'
Application.ScreenUpdating = False     '描画の停止'

End Sub

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up