Enable Calculations in VBA

[sulley333]

For some reason all of my formulas are not automatically calculating. There must be a setting that changes this. I am trying to enable them in my vba code in case another person has the same problem. When I record pressing F9 it just says calculate and I placed that in my code but doesn't work.

Is there a method that does this. For example, ActiveWorksheet.EnableCalculations? If so, how does it work?

Thanks!
Lauren

 

[Sthrncali]

Application.Calculation = xlCalculationAutomatic

 

[sulley333]

Thanks so much!!!