ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Out of Stack space error (https://www.excelbanter.com/excel-programming/427794-out-stack-space-error.html)

Ayo

Out of Stack space error
 
Does anyone know what this error is? My macro was working fine until all of a
sudden I start getting this error message and the dreaded MS excel has
encountered a problem and needs to close.
Any ideas what is going on? I just shoot down and restarted my computer.

Jim Thomlinson

Out of Stack space error
 
Out of stack space or stack overflow? The stack is where temporary variables
are stored. If you get into a recursive call or infinite loop where you are
creating variables then very quickly you will fill up the stack and run out
of memory. Perhaps your code is branching into an area that has this kind of
a problem...
--
HTH...

Jim Thomlinson


"Ayo" wrote:

Does anyone know what this error is? My macro was working fine until all of a
sudden I start getting this error message and the dreaded MS excel has
encountered a problem and needs to close.
Any ideas what is going on? I just shoot down and restarted my computer.



All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com