VBA Solver FormulaText

[mdand]

Is there any way to call a variable from VBA as the input for FormulaText in SolverAdd?

Sub ()

intX=5
SolverAdd CellRef:=Range("A1"),Relation:=1, FormulaText:=intX

End Sub

 

[shg]

What happened when you tried it?

 

[mdand]

I actually figured it out, you have to Dim the variable as a string rather than an integer. Thanks for the quick response