View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Idoia Idoia is offline
external usenet poster
 
Posts: 29
Default 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!