Thanks, IRstuff! That worked.
For anyone who might be interested, here is the working file. The parameters that Solver is going to change must be passed to the function as arguments.http://files.engineering.com/getfile.aspx?folder=5ef34efc-209a-49b7-87c1-d3249882de0e&file=TestModel.xls
Thanks for your help, IRstuff. Could you please further explain "You need to pass the parameters to the function"? I realize that with the simple example that I have included that there are many ways to find the solution. However, this is just a very simplified example of what I am trying to...
Yes, I have tried it using the file attached to my first post, but Solver returns the original input values, not the optimized values. If anyone knows how I can get solver to work with a VBA UDF, I would really appreciate the help. Thanks!
I would like to use Excel's Solver to minimize the sum of the square errors between observed data and a model. I know how to do this if the model is an Excel function in cells in the worksheet. However, I am working with a very complicated series of functions that I would like to be...
