Could you reorganize your macro so that it can be used as a user-define
function in Excell? I've used this approach for several differen
problems (mostly curve fitting type problems) and it has worked wel
for me. This way you can still use VBA to calculate the value of th
function. Because the value of the function is then returned to
worksheet cell, and the input parameters are also in worksheet cells
then you can use solver to optimize the input parameters.

I seem to recall that the developers of the solver utilit
(www.solver.com) sell extended versions that, if I remember correctly
work with several different programming languages and with extende
functionality. I've never used them myself, but it might be wort
looking into

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