Hello,

I want to automate a 'solve' procedure by using a macro button. The solve
works when manually done. But when I use a button, I get the following
compiler error.

Sub or function not defined.

Sub solve()
'
' solve Macro
' Macro recorded 25/10/2005 by IT Services
'

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



solverok is the highlighted part, that it refers to.

regards