Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem implementing SolverAdd - Can anyone solve? | Excel Programming |