Solver Macro

D

Diogo

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
 
D

Diogo

Forget it everyone

Just solved the problem:

In the VBA editor:
Tools
References
Solver add-in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top