Macro Debug
Hi TC,
Try:
Go to Tools | References in the VBE (Alt F11 --TR)
This should open the reference list.
Scroll down until you find SOLVER and verify that it is checked.
Alt Q (to return to Excel)
---
Regards,
Norman
"tcnichols" wrote in message
m...
I'm not a big macro user but I thought I knew how to record and use
one. I went to tools/macros/record new macro and record five solver
calculations and named the marcro "a." Upon running the macro I get
"Compile Error: Sub or Function not defined." Here is the macro text
below. Excel recorded all my movements in setting up the macro so
what's the problem?
' Keyboard Shortcut: Ctrl+a
'
Solverok SetCell:="$L$13", MaxMinVal:=3, ValueOf:="0.18",
ByChange:="$L$12"
SolverSolve
Solverok SetCell:="$K$13", MaxMinVal:=3, ValueOf:="0.18",
ByChange:="$K$12"
SolverSolve
Solverok SetCell:="$J$13", MaxMinVal:=3, ValueOf:="0.18",
ByChange:="$J$12"
SolverSolve
Solverok SetCell:="$I$13", MaxMinVal:=3, ValueOf:="0.18",
ByChange:="$I$12"
SolverSolve
Solverok SetCell:="$H$13", MaxMinVal:=3, ValueOf:="0.18",
ByChange:="$H$12"
SolverSolve
End Sub
|