there is a code:

..
..
..
application.calculate
..
..
..
..


application.calculate initiates calculation end execution of vba code is
continued.
How to hold code execution until calculation is finished?