SteveM,

I'm not sure I fully understand your suggestion. The solver mus
incrementally update the unknown variables (which are read into th
macro) and then repeatedly evaluate the objective function. If th
objective function is calculated in a macro, how does the solver kno
to call the macro to update the objective function for each iteratio
in the solution?

Regards,

Wil

--
wj
-----------------------------------------------------------------------
wjm's Profile: http://www.excelforum.com/member.php...fo&userid=3513
View this thread: http://www.excelforum.com/showthread.php?threadid=54896