How install solver in excel3/24/2024 SolverAdd CellRef:="$RX$1", Relation:=1, FormulaText:="87" SolverAdd CellRef:="$RX$1", Relation:=3, FormulaText:="74" SolverAdd CellRef:="$RJ$1", Relation:=1, FormulaText:="87" SolverAdd CellRef:="$RJ$1", Relation:=3, FormulaText:="74" SolverAdd CellRef:="$RI$1", Relation:=1, FormulaText:="87" SolverAdd CellRef:="$RI$1", Relation:=3, FormulaText:="74" Here is the first few lines of code to show you what I am doing in the long version. Basically it starts in one cell, runs solver, moves the target and constraint cells to the right one, solves, moves target and contraint cells to the right 14, solves, right one, solves, right 14 solves, until it finds a blank. I am trying to write a loop that performs a function using solver.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |