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 vote410 views1 answer
Filesystemobject vba reference
VBA
1 vote352 views1 answer
Excel vba unload userform
VBA
22 votes509 views1 answer
Xlvba check for folder
VBA
0 vote360 views1 answer
Vba open report
VBA
0 vote346 views1 answer
Vba len variant
VBA
0 vote369 views1 answer
Vba run command
VBA
0 vote352 views1 answer
Excel text to columns line break
VBA
0 vote344 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote324 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote343 views1 answer
Telephon call in vba
VBA