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

5 votes204 views1 answer
Excel vba get user selected range
VBA
0 vote176 views1 answer
Search in richtextbox vb.net
VBA
0 vote181 views1 answer
Excel vba copy range with filter
VBA
0 vote178 views1 answer
Excel vba copy entire sheet paste values
VBA
-1 vote185 views2 answers
Excel vba delete empty rows
VBA
0 vote132 views10 answers
Vba excel create event log
VBA
0 vote187 views1 answer
Excel vba textbox forecolor disabled
VBA
2 votes175 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote181 views1 answer
Weekday vba
VBA
0 vote179 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA