$$Excel-Macros$$ Re: Stack error problem

2008-09-23 Thread larry
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

$$Excel-Macros$$ Re: Stack error problem

2008-09-23 Thread AJIT NAVRE
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.

$$Excel-Macros$$ Re: Stack error problem

2008-09-22 Thread larry
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

$$Excel-Macros$$ Re: Stack error problem

2008-09-10 Thread Munson, Herb
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