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!