<There is NO way to get back those internal variables to a sheet..?

Indeed.
Charles gave you about all the options there are.

BTW, if the function is iterative, how did you intend to organize writing
results to a sheet?

Personally, I think setting a break-point and watching what happens to the
variables gives most insight to how the function evaluates to its result


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Don McC" wrote in message
...
There is NO way to get back those internal variables to a sheet even if
its
not the sheet from which the FUNCTION is called?? If I made some of the
internal local variables Module level variables, wouldn't that make them
available to other procedures? In this case, displaying the internal
variables in a MSG box or in a programming window is insufficient. Even
though the object of the FUNCTION procedure is the ultimate goal variable,
many of the other internal variables are important to know. I suppose the
other possible option is to make each variable that is calculated in the
code
its own FUNCTION and then call each Function from the spreadsheet. But
that
really won't work in this case because the FUNCTION I have created is
iterative and I only want the converged internal results and they have to
be
in the controlling iterative Function.

"Charles Williams" wrote:

A function that is called from a cell can only return a valaue to the
calling cell and is not allowed to modify any other cell.

If you want to see the intermediate values you could:
- add Debug.Print statements to write values to the Immediate Window
- or show the locals window and add a breakpoint to the the function
- add MsgBox statements to the function

regards
Charles

Is there a way to write out to a worksheet intermediate (internal)
variables
that are calculated in a function procedure. I have tried writing a sub
procedure that is called from the function procedure but that doesn't
seem to
work. Makes the calling function not work and I get a #VALUE instead.
In
that iteration, I was trying to print to the same worksheet that I am
calling
the function procedure from,

Thanks
.