Kevin,

Solver only works with ranges in the active sheet. Whatever
formulation you have looks for the cell values on that sheet only and
places the solution values on that same sheet.

SteveM

Kevin wrote:
I am interested in using solver but I do not want solver to autocalculate
all of my sheets. How do I set solver to just work on one area of a sheet
without it interfering with the rest of my sheets and calculating them?