Excel vba automatic calculation

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

Similar codes

2 votes115 views2 answers
Excel vba copy values range to another range
VBA
0 vote131 views1 answer
Write listbox to text file vb.net
VBA
2 votes111 views1 answer
Vba array contains
VBA
0 vote127 views1 answer
Vba variable number of arguments
VBA
0 vote135 views1 answer
Vba paste values
VBA
3 votes152 views2 answers
Vba date to string
VBA
0 vote125 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote121 views1 answer
Internet explorer reference vba
VBA
0 vote131 views1 answer
Excel vba DisplayAlerts
VBA
2 votes118 views1 answer
Date format for ms chart vb.net
VBA