Expected function or variable Error in vba

Question

'Application.Calculate = xlManual'

I put this line in my code to make calculations in manual mode, but it shows "expected function or variable" Error. Can you help?

Bathsheba · Accepted Answer · 2014-01-23 06:22:18Z

5

There is no such enumerator value. You are also using the Application object incorrectly.

Use Application.Calculation = xlCalculationManual instead

answered Jan 23, 2014 at 6:22

Bathsheba

235k35 gold badges376 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nagaraj S · Accepted Answer · 2014-01-23 06:28:45Z

1

xlCalculationManual Returns or sets a XlCalculation value that represents the calculation mode.

Application.Calculation=xlCalculationManual

answered Jan 23, 2014 at 6:28

Nagaraj S

13.5k6 gold badges36 silver badges53 bronze badges

+ 1 Or use the value Application.Calculation = -4135