Out of Stack Space Error (Error No-28)

[sachin kulkarni]

Hello everyone!!

Can anyone plz help me with this problem?
I am calling a particular procedure in VB Excel repeatedly from a another procedure.
After some time the excel hangs up and stops responding. It shows "Out of Stack Space Error"

Is there a way to clear the stack space? Is ther any other solution?

 

[Makrini]

probably a good idea to show the code. There are any number of things you could be doing that could cause this.

Usually creating more and more variables... or expanding the variables...

Or not closing objects...

 

[sachin kulkarni]

Thanks Makrini for your response.


The code is like this..

'----------

For i=1 to 76

Range("H1")=i

call subProc1

next

'------------


Here subProc1 is the main procedure which calls other Procedures to execute a particular task.
The problem is after certain loop like i=45 , the application hangs up and stops responding. I have declared all the variables as global since local vars get stored on stack.
The nos of Procedures called in subProc1 is max 5 or 6. Not more than that.

 

[Makrini]

Calling procedures in procedures in procedures is extremely bad practice..

This may help

http://support.microsoft.com/kb/126090

 

[sachin kulkarni]

Yes I agree but I am calling 4 or 5 procedures from the main procedure. I think that's fine, rit?

Btw wats happening is when i becomes =48 , the excel just hangs up, I can select the sheets but can't activate the cells and if i do Ctrl+Break the application closes.

I am pissed off by this error.

BTW 1 qn...


'----------
sub Macro1()

For i=1 to 76

Range("H1")=i

call subProc1

next



end sub
'------------

In the this scenario when I call subProc1 it will stored on the stack rit? Once its executed and control comes to Next it will automatically be removed from stack rit? then how come stack is getting filled?

 

[Makrini]

Have you tried pausing the macro a couple of iterations in - and looking at the stack?

(ie. ctrl L from VBA)

 

[sachin kulkarni]

Thanks .. I did it just now. Once cntrol reaches "next" the stack is cleared. it has only Macro1.
But donno wat happens when i=48?

 

[Makrini]

maybe its more to do with your global variables?

Kind of reaching here... maybe try a couple of iterations before 48 and walk through. Add watch to a couple of your globals particularly just in case they are getting too big.