Tom Ogilvy wrote:
to the best of my knowledge, Calculate doesn't operate asynchronously, so it
shouldn't be an issue.

If it is for some reason, then break your code into two pieces (calculate at
the end of the first). Then use Application.OnTime to start the second
section of code with an appropriate delay.


As a final answer:

Worksheet_change event doesn't work correctly if cell which changes its
value has data validation and you use drop down box to change that value.