Dear Excel Programers,
I would like to know if it is possible to use solver from within a macro,
but not with value kept in cells but with values kept in variables.
for examples, supose I have two variables:
X = 3 and Y = 2. and I want to solve the linear equation:
Y = a*X + b
I would like to pass the function a*X+b-Y to the Solver and solve for a and
b, without having to write the data to cells in a worksheet and read the
results from this worksheet.

Thanks for the help

Sincerely yours,

Avner Mediouni
R&D Physicist
email: