Thread: Solver Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diogo Diogo is offline
external usenet poster
 
Posts: 19
Default 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