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 vote216 views1 answer
Show unix time in vba
VBA
1 vote215 views1 answer
Vbscript convert ascii code to character
VBA
0 vote220 views1 answer
Excel vba saveas no prompt for overwrite
VBA
1 vote240 views1 answer
Find and replace textbox
VBA
5 votes234 views1 answer
Excel vba get low byte from INTEGER
VBA
5 votes221 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote208 views1 answer
Vb streamreader
VBA
2 votes153 views2 answers
Vba exit loop
VBA
0 vote202 views1 answer
Change whcih control a user has selected vb
VBA
0 vote245 views1 answer
Vba cell all borders
VBA