When incorporating Solver (xl2k) in macro applied
sequentially to several worksheets with links to the same
cell positions, all works fine provided it comprises no
constrains. No problem occurs either if the constrains are
being added in the first run by means of SolverAdd
function. As soon as, however, the Solver call is
repeated, constrains are SolverAdded once more, and
evermore reference is lost to the right hand member of a
relation. Solver calculation therefore crashes. How to
arrange then the formulation of constrains in Solver macro
function so that they could work forever? To refresh them
repeatedly by SolverDelete and SolverAdd?

Many thanks
PB