Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recording and playing Macro (Solver)
Hi,
I've recorded a macro that consists on using solver on a target cell. The code I get is very straightforward: SolverOk SetCell:="$N$39", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$61:$B$64" SolverSolve When I try to replay the macro, I get the compile error "Sub or Function not defined" (with "SolverOk" highlighted) I suspect it has to do with the fact that solver is an add-in, but if it's able to record it, it should be able to replay it, right? Any halp would be appreciated. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recording and playing Macro (Solver)
From VBE:
Tools References check SOLVER -- Gary''s Student - gsnu200760 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recording and playing Macro (Solver)
That worked, thanks a lot.
"Gary''s Student" wrote: From VBE: Tools References check SOLVER -- Gary''s Student - gsnu200760 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recording and playing Macro (Solver)
I've exactly the same problem plus one mo the Reference command under Tool
is dim and cannot be activated? "Idoia" wrote: That worked, thanks a lot. "Gary''s Student" wrote: From VBE: Tools References check SOLVER -- Gary''s Student - gsnu200760 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detecting the actual playing or NOT playing of a WAV file | Excel Discussion (Misc queries) | |||
recording a macro | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |