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

0 vote331 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote303 views1 answer
Check range is in another range vba
VBA
0 vote298 views1 answer
Do until vb.net
VBA
0 vote303 views1 answer
Vlookup columns not next to each other
VBA
5 votes341 views1 answer
Excel vba tool to help with refactoring code
VBA
1 vote333 views1 answer
Set font for ms chart vb.net
VBA
0 vote348 views1 answer
Vba boolean to string
VBA
5 votes377 views1 answer
Vba low byte from INTEGER
VBA
0 vote340 views1 answer
Vba extract filename from path
VBA
0 vote309 views1 answer
Vbscript abs
VBA