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 |
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 |