Out Of Stack Space

Hello,
I have written a macro and it works fine, no coding errors but it seems
limited by the "Stack" it can only operate on so many lines at one go. hence
i get an error message "Out Of Stack Space"

Any help please?

thanks

Andy

Generally this is caused if you have recursive calls to the function.
Perhaps if you posted your code and an explanation of what it does, someone
might be able to see if that is a problem.

--
Regards,
Tom Ogilvy

"Momo" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I have written a macro and it works fine, no coding errors but it seems
> limited by the "Stack" it can only operate on so many lines at one go.
hence
> i get an error message "Out Of Stack Space"
>
> Any help please?
>
> thanks
>
> Andy

OK will do when i have time,
thanks
Andy
"Tom Ogilvy" wrote:

> Generally this is caused if you have recursive calls to the function.
> Perhaps if you posted your code and an explanation of what it does, someone
> might be able to see if that is a problem.
>
> --
> Regards,
> Tom Ogilvy
>
> "Momo" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> > I have written a macro and it works fine, no coding errors but it seems
> > limited by the "Stack" it can only operate on so many lines at one go.
> hence
> > i get an error message "Out Of Stack Space"
> >
> > Any help please?
> >
> > thanks
> >
> > Andy
>
>
>