ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Claculation in left corner (https://www.excelbanter.com/excel-programming/347634-claculation-left-corner.html)

James McDowell[_2_]

Claculation in left corner
 
I have inherited a spreadsheet and it continuousely shows the work Calculate
in the left corner of the application.

Is there a script in VBA that I can run that will tell me what cells require
the calculation?

I have the options set to automatic and have re-calced several times. This
is driving me nuts!!!

Niek Otten

Claculation in left corner
 
http://www.decisionmodels.com/calcsecretsf.htm

--
Kind regards,

Niek Otten

"James McDowell" wrote in message
...
I have inherited a spreadsheet and it continuousely shows the work
Calculate
in the left corner of the application.

Is there a script in VBA that I can run that will tell me what cells
require
the calculation?

I have the options set to automatic and have re-calced several times.
This
is driving me nuts!!!





All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com