+ Reply to Thread
Results 1 to 4 of 4

Runtime Error 28 Out of stack space = headache!

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    Runtime Error 28 Out of stack space = headache!

    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.
    Last edited by Cutter; 09-21-2012 at 09:05 PM. Reason: Added code tags

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Runtime Error 28 Out of stack space = headache!

    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.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Runtime Error 28 Out of stack space = headache!

    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.

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Runtime Error 28 Out of stack space = headache!

    @ 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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1