Force Goalseek to use only positive values in the variable cell?

[John Richards]

I used Goalseek in a simple VBA program and now the macro is returning
negative values for the cell value to be changed! Is there a simple way to
limit the values used in the iteration to only positive values? It appears
that Solver will do what I want, but I haven't figured out yet how to use
solver.

Thanks,

John

 

[John Richards]

Disregard my question. I had made another change on the worksheet that
actually made a result get smaller instead of larger as the variable got
larger. To force the result to be larger, Goalseek actually had to reduce
the value of the variable and eventually found a negative value that forced
the result to increase to the goal. I just have to figure out how to
correct the change I had made on the worsheet.

John