Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver Macro
Hi
New doubt! Just recorded this simple Macro: Sub Datinfor() ' ' Datinfor Macro ' Macro recorded 14-01-2008 by dbranco ' ' SolverOk SetCell:="$D$27", MaxMinVal:=3, ValueOf:="0", ByChange:= _ "$D$6:$D$12,$D$14:$D$19,$D$22:$D$25" SolverSolve End Sub It returns me the following: Compile error: Sub or Function not defined Highlighting the "SolverOk" portion of the Macro. Could someone help? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver Macro
Forget it everyone
Just solved the problem: In the VBA editor: Tools References Solver add-in "Diogo" wrote: Hi New doubt! Just recorded this simple Macro: Sub Datinfor() ' ' Datinfor Macro ' Macro recorded 14-01-2008 by dbranco ' ' SolverOk SetCell:="$D$27", MaxMinVal:=3, ValueOf:="0", ByChange:= _ "$D$6:$D$12,$D$14:$D$19,$D$22:$D$25" SolverSolve End Sub It returns me the following: Compile error: Sub or Function not defined Highlighting the "SolverOk" portion of the Macro. Could someone help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to run Solver using a macro? | Excel Worksheet Functions | |||
Solver macro | Excel Programming | |||
Macro for Solver | Excel Programming | |||
Using Solver within Macro | Excel Programming |