Recording and playing Macro (Solver)

  • Thread starter Thread starter Idoia
  • Start date Start date
I

Idoia

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!
 
I've exactly the same problem plus one more: the Reference command under Tool
is dim and cannot be activated?
 
Back
Top