How to use Solveradd for step parameter?

[alee001]

I want to VBA Solver search parameter array like as 5, 8, 11, 14, 17...60 step 3, I use SolverAdd code as follow but not work?Why
[W4] as parameter start 5
Range("step") = 3

SolverAdd CellRef:=[W4], Relation:=2, FormulaText:=2+Range("step")*Int([W4]/Range("step"))

 

[alee001]

Improve code:
[W4] as change parameter
Range("p1") as start parameter (i.e. 5)
[

SolverAdd CellRef:=[W4], Relation:=2, FormulaText:=Range("p1") Mod Range("step")+Range("step")*Int([W4]/Range("step"))

 

[alee001]

I also tried follow code but not work too?

SolverAdd CellRef:=[W4] Mod Range("step"), Relation:=2, FormulaText:=Range("p1") Mod Range("step")

 

[Jon Peltier]

I don't think FormulaText can actually include a formula. It can be a value, a cell address, or the name of a named cell.

 

[alee001]

After constant testing, the following code can control Solver searching by step parameter.
[W4] as change cell
[A1] as start parameter
[A2] as step no.
[W5] =IF(AND(A1-INT(A1)=0,A1>1),IF(MOD(W4,A2)=MOD(A1,A2),1,0),IF(MOD(W4*100,A2*100)=MOD(A1*100,A2*100),1,0))

SolverAdd CellRef:=[W5], Relation:=2, FormulaText:=1