excel vba automatic calculation

The solution for “excel vba automatic calculation” can be found here. The following code will assist you in solving the problem.

Sub CalculationMode()
‘ To manual
Application.Calculation = xlManual
‘ One shot Recalculation (one worksheet), keeps Calculation mode to manual
ThisWorkbook.Worksheets(1).Calculate
‘ To automatic
Application.Calculation = xlAutomatic
End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts