Forum Discussion
FedericoScarpa
Jul 23, 2024Copper Contributor
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.