Hi there!

I have a spreadsheet where one column outputs values based on a single variable on the spreadsheet (the calculations are done through a function within a VBA macro). I would like to "curve fit" the calculated values to a second column containing "test data" by forcing the Root Square Sum to 0 with the help of the Solver. I'm able to initiate the solver through VBA which in turn calls the function (through ShowRef). The problem is that the solver doesn't do anything It takes the initial value of the variable, calculates the column using the function and then recalculates the column using the same unchanged value. I know there are simpler ways of doing this ie by using a simple equation within the spreadsheet instead of doing everything within VBA. But I will be applying this to a much larger complicated spreadsheet where everything is within VBA.
I'm working with Excel 2000. I apologize I can't show any code but I don't have access to it at the moment. Please let me know if there are any clarifications necessary! In advance thank you for your help.
Aleks