我的宏计算如何防止Excel呈现电子表格？ [英] How do I prevent Excel from rendering the spreadsheet as my macro calculates it?

问题描述

我的宏使用数字更新大型电子表格，但是运行速度非常慢，因为excel在计算结果时渲染结果。

解决方案

我使用两个提出的解决方案： p>

  Application.ScreenUpdating = False 
 Application.Calculation = xlCalculationManual 
 ... 
 ... 
 ... 
 Application.Calculation = xlCalculationAutomatic 
 Application.ScreenUpdating = True 
  

My macro updates a large spreadsheet with numbers, but it runs very slowly as excel is rendering the result as it computes it. How do I stop excel from rendering the output until the macro is complete?

解决方案

I use both of the proposed solutions:

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
...
...
...
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

这篇关于我的宏计算如何防止Excel呈现电子表格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！