hi twd000,

I imagine that one of the sections (see links under the page header) of the below page will give you all your answers & more!

When you start reading, you'll know why I haven't tried to answer you directly - my responses would be straight from Charles' page. I'm not sure (from memory) if he discusses Solver specifically or not.

http://www.decisionmodels.com/calcsecrets.htm

In particular, check out the links called "Calculation Methods" & "Calculating from VBA".

hth
Rob