Thread: Calling a macro from SOLVER (Excel 2007)

I have the following problem.

-------------------------------------------------------------------------------------------
I have a table of values

a macro compute the values in the table and put the result in a Cell (let's say "C1").

--------------------------------------------------------------------------------------------

I would like to use SOLVER to minimize the value in "C1".

I can use solver to change the value in the table but how can I ask SOLVER to call the macro to compute the values in the table?

Thanks in advance for any idea you may have,

Why don't you write a macro to call SOLVER then call the macro which computes the values?

CC