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 vote132 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote120 views1 answer
Vba DisplayGridlines
VBA
0 vote123 views1 answer
Vbnet get file name from path
VBA
0 vote126 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote121 views1 answer
Excel vba copy range with filter
VBA
0 vote134 views1 answer
Find database connection string vb
VBA
0 vote160 views2 answers
VB
VBA
1 vote140 views1 answer
Vb.net get name by Cell Click
VBA
0 vote126 views1 answer
Vba sheet hide unhide
VBA
0 vote130 views1 answer
Vba add spaces
VBA