| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a variable in solver
THANKS! It works perfectly know.
"Stephen" wrote: I am tring to use a macro so that a user can input a number into a call and when the macro is run the solver references that cell.(e25 in this case.) When I run the code it seems to default to the current settings in the solver and not the referenced cell. I have tried resetting the values on the solver. Anyone have any thoughts. Here is the code I am using: SolverOk SetCell:="$B$25", MaxMinVal:=0.01, _ ValueOf:=Range("$e$25").Value, _ ByChange:="$B$22" SolverSolve Thanks. Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solver with binary variable | Excel Discussion (Misc queries) | |||
| Multiple or Variable cell references in Solver (Excel 97) | Excel Worksheet Functions | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| solver can not solve polynomial eq. where one variable is five di. | Excel Worksheet Functions | |||
| Resetting Solver Manually to Fix Solver Bug | Excel Programming | |||
Threaded Mode
