I have a worksheet with a sircular refrence. I'm using Iterations to control this sircular refrence. My problem is that I need to interact with the Iteration process.
I need to stop the Iteration process when one of the cells in the sircular refrence reaches a specific value. To do this, I need to check values in a cell in each iteration loop using VBA or some worksheet function.
Is it possible ??
I tried the Worksheet_Calculate and Workbook_SheetCalculate events, but they are triggered after the iteration loop is finished!