Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using solver in macros - Help
Anyone give us an idea about this one?. When I run this
basic macro, the settings of SolverOK do NOT get inputted into the solver addin but the constraints do. (i.e. SolverAdd works, SolverOK does not). I have tried using R1C1 notation as suggested by help queries and same thing happens (or doesn't happen!). If I manually record, VBA recognises that I am using SolverOK and records my actions, but when I play back, the macro totally ignores the solverOK line. Any suggestions? Thanks Toby Sub SolveMacro() SolverReset SolverAdd CellRef:="$B$1", Relation:=2, FormulaText:="0.1" SolverOK SetCell:="$A$1", MaxMinVal:=1, ValueOf:="0", ByChange:="$C$1:$C$4" SolverSolve True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solver in macros | Excel Discussion (Misc queries) | |||
Macros involving SOLVER... function | Excel Discussion (Misc queries) | |||
webquery and solver macros | Excel Discussion (Misc queries) | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
Solver, macros Excel | Excel Worksheet Functions |