Forum Discussion
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...
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.