Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can some one help to modefy the following code wherein I can run
the macro on 250 cells across a table/or matrix form. SolverOk SetCell:="$F$52", MaxMinVal:=3, ValueOf:="0",_ ByChange:="$C$52" SolverAdd CellRef:="$C$52", Relation:=3, FormulaText:="0" SolverSolve True SolverOk SetCell:="$F$53", MaxMinVal:=3, ValueOf:="0",_ ByChange:="$C$53" SolverAdd CellRef:="$C$53", Relation:=3, FormulaText:="0" SolverSolve True end sub I need to run the solver on coloumns f to k on 20 cells each. Can I use a range command or offset command to keep changing the target cells over and over. Some loop structure would do ,I suppose. Since I have never worked on this before, I would like a jum- start on solver. The constraints will be set as shown. thank you very much for the timely help, in advance. -- beetal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Several target cells in the solver | Excel Discussion (Misc queries) | |||
deleting cells that are controlled using Target code | Excel Discussion (Misc queries) | |||
How do I set more than 1 target cell using MS Solver? | Excel Worksheet Functions | |||
target cells in solver | Excel Programming | |||
Goalseek / Solver Target Value | Excel Worksheet Functions |