Hi,
I want to loop a solver constraint which goes something like below
( solverAdd cellref:="$k$29", Relation:=2, formulatext:="$I$23*$K$28")
I need to loop this nearly to 100 cells.
Now im copying and changing it manually.Tried wih for loop but the constraints are not added.
Question 2:
I want a code to accept solver constraints @ run time
like set a value of cell to zero during run time.
Please help me with these two questions.
Thanks
I want to loop a solver constraint which goes something like below
( solverAdd cellref:="$k$29", Relation:=2, formulatext:="$I$23*$K$28")
I need to loop this nearly to 100 cells.
Now im copying and changing it manually.Tried wih for loop but the constraints are not added.
Question 2:
I want a code to accept solver constraints @ run time
like set a value of cell to zero during run time.
Please help me with these two questions.
Thanks