Tom Ogilvy wrote:
How can a calculate fire a Change event.

You are right calculate doesn't fire worksheet_change, but it doesn't
change my situation



More likely a change event fires a calculate.

in automatic calculation yes

in manual you must do this manualy by calling application.calculate or
activesheet.calculate or similar.
but the problem is if code in worksheet_change needs updated data.
There is no way to wait until calculation is finished.