ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   could not get solverget working (https://www.excelbanter.com/excel-programming/339873-could-not-get-solverget-working.html)

[email protected]

could not get solverget working
 
I try to dump the solver parameters on a spread sheet. I find the
following problems.

SolverGet(4) returns an #Value! error. it is supposed to return an
reference to the changing cell.

SolverGet(7) returns a blank array. It is supposed to an array of
numbers, which indicate the signs of constraints.

Others seem to work well.
anybody know how to address this problem?





thanks,
De

PS: Solver sucks! It offers unfriendly and poorly documented program
interface.


tjtjjtjt

could not get solverget working
 
Please post something more detailed for an in depth response.

You can always look at www.solver.com for more information.

--
tj


" wrote:

I try to dump the solver parameters on a spread sheet. I find the
following problems.

SolverGet(4) returns an #Value! error. it is supposed to return an
reference to the changing cell.

SolverGet(7) returns a blank array. It is supposed to an array of
numbers, which indicate the signs of constraints.

Others seem to work well.
anybody know how to address this problem?





thanks,
De

PS: Solver sucks! It offers unfriendly and poorly documented program
interface.




All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com