Dear allstaters,
I am trying to use this command below to add constraints to the solver
within a VBA program which updates an excel spreadsheet.
For u = 1 To ilength
SolverAdd CellRef:=Chr(imin + u - 1) & (jmax + 2), Relation:=2,
FormulaText:=Chr(imax + 2 + u - 1) & 13
Next
My problem is that Excel do not understand the cell reference on the right
handside of the Formula.Text option. There is no error message. The cell
reference the solver is using is a different one.
Can anyone help?
Cheers,
Philippe Guiblin
ONS London
For the latest data on the economy and society
consult National Statistics at http://www.statistics.gov.uk
**********************************************************************
Please Note: Incoming and outgoing email messages
are routinely monitored for compliance with our policy
on the use of electronic communications
**********************************************************************
Legal Disclaimer : Any views expressed by
the sender of this message are not necessarily
those of the Office for National Statistics
**********************************************************************
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
|