View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Anderson[_2_] Tim Anderson[_2_] is offline
external usenet poster
 
Posts: 3
Default Problem with SolverAdd. Can anyone help?

I accidentally hit the send button before I was finished...
As I was saying...

I'm trying to add a variable number of constraints to
Solver using VBA 6.0. The following snippet of code works
fine on a machine that has VBA 6.3 installed, but NOT on
my machine that has VBA 6.0 installed:

'Insert new constraints
For i = 1 to NumRows
SolverAdd CellRef:=Range("MatrixLLT").Cells(i,i),
Relation:=2, FormulaText:="1"
Next i

Can anyone propose a way to make this routine work in VBA
6.0?

Thanks!
Tim Anderson