Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver in Visual Basic
Hi!
Can anyone help me? I'm writing a programme with VB and I need to use the solver Add-In, by recording a macro I tried using: SolverOk SetCell:="$k+1$3", MaxMinVal:=1, ValueOf:="0", ByChange:="$k+1$4" SolverAdd CellRef = "$k+1$4", Relation:=3, FormulaText:="0.000001" SolverSolve But this doesn't work. Also, the macro I obtaine contained letters as row references so I'm not sure if the "k+1" would work?I'd be very grateful for any suggestions! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
New to Visual Basic | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic Macro For Solver | Excel Programming | |||
Visual Basic | Excel Programming |