software_development:performance_of_vba

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
software_development:performance_of_vba [2017/03/03 13:34] – removed prgramsoftware_development:performance_of_vba [2025/07/07 14:12] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +<code vb>
 +Application.ScreenUpdating = False
 +Application.DisplayStatusBar = False
 +Application.Calculation = xlCalculationManual
 +Application.EnableEvents = False
  
 +Application.ScreenUpdating = True
 +Application.DisplayStatusBar = True
 +Application.Calculation = xlCalculationAutomatic
 +Application.EnableEvents = True
 +
 +
 +열려 있는 모든 통합 문서        Application.Calculate (또는 Calculate)
 +특정 워크시트        Worksheets(1).Calculate
 +특정 범위        Worksheets(1).Rows(2).Calculate
 +Worksheets(""Sheet1"").UsedRange.Columns(""A:C"").Calculate
 +
 +range("A1").FormulaR1C1 = "=TODAY()"
 +Range("F2") = Evaluate("SUM((B2:B60001=E2)*C2:C60001)")
 +</code>
  • software_development/performance_of_vba.1488548080.txt.gz
  • Last modified: 2025/07/07 14:12
  • (external edit)