Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Debug
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Debug
Norman, thanks but References is grayed out. Ideas?
"Norman Jones" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Debug
Norman, thanks but References is grayed out. Ideas?
"Norman Jones" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Debug
Hi TC,
Norman, thanks but References is grayed out. Ideas? This would happen if you were in break mode. Try setting the Solver reference after pressing your macro reset button. --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Debug Error | Excel Discussion (Misc queries) | |||
Locking debug mode in a macro | Excel Worksheet Functions | |||
How do I resolve debug error macro Excel 2000? At least, any lead | Excel Discussion (Misc queries) | |||
No debug box | Excel Programming | |||
debug - | Excel Programming |