ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Forcing a Calculate Now? (https://www.excelbanter.com/excel-programming/389653-forcing-calculate-now.html)

gtslabs

Forcing a Calculate Now?
 
Is there a command that will force the workbook to recalcualte that I
can put at the beginning of my macro?


Norman Jones

Forcing a Calculate Now?
 

Try:

Application.Calculate


---
Regards,
Norman




"gtslabs" wrote in message
oups.com...
Is there a command that will force the workbook to recalcualte that I
can put at the beginning of my macro?




PCLIVE

Forcing a Calculate Now?
 
Application.Calculate


"gtslabs" wrote in message
oups.com...
Is there a command that will force the workbook to recalcualte that I
can put at the beginning of my macro?





All times are GMT +1. The time now is 05:26 PM.

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