Hello,

I am trying to automate the 'solver' function so that we dont have to go
through the menu to get the solver answer.

The solver works and excel finds feasible solutions. But when attaching a
macro, to this the following compiler error appears.



Sub Macro1()
'
' Macro1 Macro
' Macro recorded 28/10/2005 by IT Services
'

'
SolverOk SetCell:="$E$9", MaxMinVal:=2, ValueOf:="0",
ByChange:="$D$2:$D$7"
SolverSolve
End Sub


with the 'SolverOk' code highlighted in blue. And then the Sub Macro1()
code, highlighted in yellow.

What the problem with this macro.

regards