Hi!

I want to create a function that does the following
1. Is a function
2. gets data from external datasources
3. does calculations
4. optimizes using the solver (minimize the square sum of errors of a formula)
5. returns the value (as a normal function)

All this is straightforward, however, I would like not to use cell
references and
use variables directly in the VBA code instead of i.e. creating a new
spreadhseet,
inserting the values, running the solver from vba, reading the result and
deleting the
worksheet, and then returning the result. In other words I would like to run
the solver internally in the code without using cells in Excel.

I hope this was somewhat clear, since I'm not a programmer. All other steps
than the solver in my code is relatively easy, but I don't seem to be able to
put my mind as to how the solver should work without cell references (using
variables instead).

Does anyone have a suggestion?