Solver Constraint use range with formulatext

Question

I have a very short question, but I simply dont get why this isnt working.

I have a solver constraint set up. The following code is working (row 14 is going to be the changeable variables, while row 13 will be the constraints).

SolverAdd CellRef:=ws1.Range(ws1.Cells(14, 2), ws1.Cells(14, 5)), Relation:=1, FormulaText:="$B$13:$E$13"

So I thought that following should be working as well

SolverAdd CellRef:=ws1.Range(ws1.Cells(14, 2), ws1.Cells(14, 5)), Relation:=1, FormulaText:=ws1.Range(ws1.Cells(13, 2), ws1.Cells(13, 5))

And I am sitting here, scratching my head and wondering why I get an error (undefined internal error or too less usable ram).

Amorpheuses · Accepted Answer · 2017-02-17 20:41:34Z

1

FormulaText is expecting a string - so if you add 'Address' to the end of the range it should work:

SolverAdd CellRef:=ws1.Range(ws1.Cells(14, 2), ws1.Cells(14, 5)), Relation:=1, FormulaText:=ws1.Range(ws1.Cells(13, 2), ws1.Cells(13, 5)).Address

answered Feb 17, 2017 at 20:41

Amorpheuses

1,4231 gold badge9 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Progressive Over a year ago

Oh, I see. Works fine. Ty :)

Amorpheuses Over a year ago

Common enough mistake, I've done it a ton of times myself.

Progressive Over a year ago

Another question: Is it possible to use a variable, lets call it x, in the CellRef part of it? I know it clearly say CellRef, but maybe there is a way around

Amorpheuses Over a year ago

As long as variable x is defined as a Range variable (ie 'Dim x As Range') and it's set properly, that should work.

Progressive Over a year ago

It did, thanks again. But one last question: it is not possible to write the results from the solver directly to an array, is it?

|

Collectives™ on Stack Overflow

Solver Constraint use range with formulatext

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related