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

31 votes258 views1 answer
Vba how to convert a column number into an Excel column
VBA
-1 vote199 views1 answer
Text to speech vb.net
VBA
0 vote212 views1 answer
Get current year vb
VBA
0 vote225 views1 answer
Vba nested dictionary
VBA
0 vote210 views1 answer
Vbnet line graph smooth lines
VBA
0 vote205 views1 answer
Vba format currency
VBA
0 vote211 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote211 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote230 views1 answer
Test if form is open vb
VBA
0 vote226 views1 answer
Vba cell all borders
VBA