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

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