Forum Discussion

FedericoScarpa's avatar
FedericoScarpa
Copper Contributor
Jul 23, 2024

iterative calculations and macro

I perform iterative calculation in a sheet and I need to call a very demanding VBA macro when calculation reached convergence. I dont want to check convergence (tolerance, iteration number) by myself since Excel controls the convergence. Is there a variable (or event?) that tell me excel finished to iterate? is there a way to call a macro from the sheet without buttons or the like, that is automatically when a cell assume a certain value? thx

  • I haven't tested it, but does the Worksheet_Change event do what you want? Downside is that it fires whenever Excel performs any calculation in the sheet.

Resources