Runtime Error 28 Out of stack space = headache!

**SportyJim1979** · 09-21-2012, 03:54 PM

Hello there,

Im having trouble with a macro... Im trying to run a macro from a Worksheet_Calculate

Although the macro is activating it seems to get caught in a loop and comes up with a Runtime Error 28 Out of stack space message. I've tried a few ways around it but nothing seems to work. The Macro does move around to different sheets which seems to cause the problem. The code is below, and help greatly appreciated!

Please Login or Register  to view this content.

**shg** · 09-21-2012, 03:58 PM

I have no idea what your code is doing, but if any of the subs are writing to the worksheet, it will retrigger the Calculate event, which will, by and by, run out of stack space.

I've never had the need to run code in the Calculate event, and wonder why you're doing so.

**SportyJim1979** · 09-21-2012, 04:07 PM

Hello shg - thanks for the quick response.

Yes - unfortunately the subs are changing that worksheet (amongst others).

Im struggling to find a way around not using code to change the desired fields. This is a direct link into a betting exchange which has live prices / volume on a different page, constantly changing.

**Cutter** · 09-21-2012, 09:06 PM

@ SportyJim1979

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.