Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
Hi,
I've got a macro that does a "Solver" calculation that updates many cells in 5 different workbooks.
I think the macro would run quicker if the workbooks were not updating all the time. (They are all open)
Is there a way of adding code to the macro so any updating of the 5 workbooks are completed at the end of the macro?
I've attached the Macro for information
Thanks for your assistance
I've got a macro that does a "Solver" calculation that updates many cells in 5 different workbooks.
I think the macro would run quicker if the workbooks were not updating all the time. (They are all open)
Is there a way of adding code to the macro so any updating of the 5 workbooks are completed at the end of the macro?
I've attached the Macro for information
VBA Code: