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 vote182 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
31 votes348 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote171 views1 answer
Hello world vb.net
VBA
4 votes189 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote194 views4 answers
Vgrive,deb
VBA
13 votes345 views2 answers
Vba write text file
VBA
0 vote173 views1 answer
Enable macros on opening workbook vba
VBA
5 votes195 views1 answer
Excel vba second byte from INTEGER
VBA
7 votes196 views1 answer
Excerl vba array to range
VBA
27 votes328 views2 answers
Vba check if file exists
VBA