Adding Solver Constraint with Variable Cell References

[MikeyT]

This is my first post as I'm a VBA novice. I'm working on an Excel tool that uses Solver to optimize a model. I'm trying to minimize the user's requirements in setting up and running Solver by a few loops for identifying independent variables and constraints. The loops work fine in identifying the variables and constraints, but I have been unsuccessful in adding the constraints to Solver.

Here is the line of code that does not seem to be working.

SolverAdd CellRef:="Cells(TargetRow, ActCol)", Relation:=1, FormulaText:="Cells(TargetRow, MinCol)"

I would really appreciate recommendations from the Mr. Excel experts.

Thank you in advance.