The functions were three lines- function, equation, function end.
Since the equations did not use functions there was no typical
recursion. However, I believe since the functions= !value# for some
reason, this resulted in the stack error.
AJIT NAVRE wrote:
> Could you please mail the file. Need t
Could you please mail the file. Need to take a look at the source data and
other supporting routines, to see if it is an infinite chain of recursion
and if it can be eliminated.
regards,
Ajit
On Mon, Sep 22, 2008 at 6:29 PM, larry <[EMAIL PROTECTED]> wrote:
>
> I should of posted the functions.
I should of posted the functions. Apparently I was causing a
disconnect because the functions even though (marginally) acceptable
code in VBA were giving me !value# in Excel. Once I gave up on the
functions and just coded the formulas, the program ran correctly.
Munson, Herb wrote:
> If there is
If there is explicit or implicit recursion going on, you can get a stack
overflow problem. For example, if EIC calls PC, and PC calls EIC, you can
generate a call stack of such depth that you run out of stack space.
I will confess, though, that I have not looked at the code you included in any