Thank you, Nigel!
When I record the macro I press the Enter button when Solver Results window
appears to close it before I click the Stop recording macro button, but the
macro does not close the window. How to make the macro close the window?
"Nigel" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
...
Solver is not recognised by the standard Excel object model, add a
reference
to SOLVER in your VB Editor.

Goto VB Editor (Alt-F11) , select Tools-References then check the SOLVER
option.- the SOLVER add in must be installed for this to be visible.

--
Cheers
Nigel



"Dmitry" wrote in message
...
Hello
I receive:
"Microsoft Visual Basic
Compile error:
Sum or Function not defined" after I have run a macro. I recorded the
macro.
The macro code is:
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 24.03.2006 by Dmitry Kopnichev
'

'
Range("J16").Select
SolverOk SetCell:="$J$16", MaxMinVal:=1, ValueOf:="0",
ByChange:="$F$4:$I$12"
SolverSolve
End Sub
All recorded operations work by itself. How to make the macro run the
operations?