+ Reply to Thread
Results 1 to 2 of 2

Error: "Out of stack space"

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    Exclamation Error: "Out of stack space"

    Hi All ,

    I need help with my macro!

    my macro comes up with an ERROR "out of stack space. when it runs this macro. bassically i want it to run the macro only when i select a matrix of calls, IE row row 5, column 3, row 5, colum 5, row 5 column 7, row 7, column 3..and onwards,

    Depending on which cell is selected as the target then it sets a probabily and impact slection that finds rows that match that critera.
    IE row 3 column 5 , is low probability medium Impact.

    It then copies specific cells in the row to a different tab, and then goes down to the next row to see if that matches the criteria.

    Marco below.


    Please Login or Register  to view this content.

    Hope you can help!!

    Rich
    Last edited by richbennett; 03-11-2010 at 12:59 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: HELP-Error "Out of stack space macro!"

    Try disabling events whilst in your event code so the changing of cells does not cause the event to fire again.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ 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