I'm trying to use solver in a macro and for some reason it won't find
solutions when run from the macro. When I run it from the toolbar on
the same cell it works perfectly.

I recorded the operation when I ran it manually to get the code for my
macro. Here's what the recording came up with-

SolverReset
SolverOk SetCell:="$i$14", MaxMinVal:=2, ByChange:="$i$15"
SolverChange CellRef:="$i$14", Relation:=3, FormulaText:="$i$13"
SolverSolve

Like I said, when I run solver in the worksheet, it works and that's
the code it records. When I run the macro it does not work. Can
anyone help me understand what's going on here?

Thanks-


--
dlowie
------------------------------------------------------------------------
dlowie's Profile: http://www.excelforum.com/member.php...o&userid=26676
View this thread: http://www.excelforum.com/showthread...hreadid=399470

See the responses in the other discussion on the same subject that you
started in the same newsgroup!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I'm trying to use solver in a macro and for some reason it won't find
solutions when run from the macro. When I run it from the toolbar on
the same cell it works perfectly.

I recorded the operation when I ran it manually to get the code for my
macro. Here's what the recording came up with-

SolverReset
SolverOk SetCell:="$i$14", MaxMinVal:=2, ByChange:="$i$15"
SolverChange CellRef:="$i$14", Relation:=3, FormulaText:="$i$13"
SolverSolve

Like I said, when I run solver in the worksheet, it works and that's
the code it records. When I run the macro it does not work. Can
anyone help me understand what's going on here?

Thanks-


--
dlowie
------------------------------------------------------------------------
dlowie's Profile: http://www.excelforum.com/member.php...o&userid=26676
View this thread: http://www.excelforum.com/showthread...hreadid=399470