I'm not sure what it is you're trying to accomplish. I
have loaded solver set cell, constraints, etc. and solved
for a result without any user dialog with solver. The
resulting optimal solution was put into the designated
cells of a worksheet. Is this what you are trying to do?

Joe
-----Original Message-----
I am writing a macro tool for the solver function and i
don't want the
solver results box to pop up in the worksheet, i just
want to use the
solver values, How do i do this?

http://www.frontsys.com/mlvbaref.htm

HTH,

Merjet


.