ExcelBanter - Auto Calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Auto Calculation (https://www.excelbanter.com/excel-programming/298445-auto-calculation.html)

Kevin

Auto Calculation

How can I write a piece of code to make sure auto
calulcation is on when I run a program using VBA? Also,
is there a way I can type in a forula in a cell of Excel
to automatically state if autocalc is on or off?

Thank you

Chris

Auto Calculation

Application.Calculat

----- Kevin wrote: ----

How can I write a piece of code to make sure auto
calulcation is on when I run a program using VBA? Also,
is there a way I can type in a forula in a cell of Excel
to automatically state if autocalc is on or off

Thank yo

Chris

Auto Calculation

To turn it on: Application.Calculation = xlCalculateAutomati

All times are GMT +1. The time now is 02:14 AM.