Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver isn't working...
Hi Stas,
On the machine where this error occurs, open the VBE, choose Tools/References from the menu and you should see a reference prefixed with MISSING. I suspect it's the reference to solver, in which case solver is probably not installed on that machine. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Stas" wrote in message ... When I try to run a macro that uses solver, I always get this error message: Compile Error. Can't find project or library. I have selected Solver from the References list so I don't know what else to do. After debugging it poitns to the SolverOK line: SolverOk SetCell:="$Z$30", MaxMinVal:=2, ValueOf:="0", ByChange:="$T$32:$W$32" SolverSolve (True) It's a 2002 version of Excel - the macro works fine with Excel 2000. Thanks for you help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver not working | Charts and Charting in Excel | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
Solver | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
solver | Excel Discussion (Misc queries) |