Trying to run SOLVER through macro

[M. A. Mian]

Hello:

I am trying to run SOLVER through a macro but it is giving
me error and the macro is not at all performing what I
want it to do.

Could you please assist me with this problem. I wish to
send you the worksheet that I am using SOLVER on but

 

[Frank Kabel]

Hi
please explain with some more detail:
- what kind of coe you're using (paste the relevant parts of your code)
- what exact error did you get (compile error, etc.)

 

[Ken Wright]

Have you set a reference to Solver??

Take a look at Help on solver and pick any of the Solver functions offered and
you will see something like the following:-

Before you use this function, you must establish a reference to the Solver
add-in. With a Visual Basic module active, click References on the Tools menu,
and then select the Solver.xla check box under Available References. If
Solver.xla doesn't appear under Available References, click Browse and open
Solver.xla in the \Office\Library subfolder.