Using Solver With Another Iterative Routine

hi kubota1000,

Is there a way to know how many passes are required? here is a simple loop you could use, this loops 10 times

  For i = 1 to 10
        Cells(i, 1) = i     'your code goes here
    Next i

Will an error occur when minimizing is complete, and you try to run the code again?

Hi, thanks for your help and suggestion.

The number of iterations made by the integrator is not known in advance. It is highly dependent on the integrand, and on the specified precision, both of which are changeable, and are passed as arguments.

The integrator does not use any previously calculated values for its initial data. The sequence of X values is recalculated all over again, and the integrator simply repeats its process and exits with the same result.

When the integrator converges, it puts its final result into a cell. I'm trying to get Solver to (then) use that cell as the Target cell, and to then change two other cells used by the integrand expression.

It does seem that Solver has to be "put on hold" while it waits for the integrator to complete its iterative work, and to then exit its code. Only then should Solver read the target cell (the calculated integral value provided by the integrator), and make its changes to the changing cells as required.

Then, the integrator has to be called again, to calculate the integral using the new changing cells data, while Solver rests up for a while... etc, etc, until the Solver exits.

Any ideas appreciated.